Hi there, I have a quick question regarding formulas in Excel.

I need to count the number of times the strings 'SS' and 'G' (they are in the same column) appears as a total (ie the sum amount both SS and G appears) in a spread sheet only when the value in another column is say for instance 'Apple'.

I have tried several combinations with COUNTIF, but nothing seems to work.

Hope this makes sense

Thank you in Advance

If you have 2007 look at the =COUNTIFS() (note the S at the end) function. MIKE

Sadly no, I have 2003 still

Try this: =IF(COUNTIF(C1:C11,"apple")>0,COUNTIF(A1:A11,"s")+COUNTIF(A1:A11,"g"),"")

Not sure it's what your looking for, but

IF the word Apple appears anywhere in Column C row 1 thru 11

Then we count the number of letters S and G in column A cell 1 thru 11

MIKE

Nope, it didn't work, but that's ok I've decided to just use a pivot table instead. I tried to avoid it, but seems like it's the easiest option. Thanks for the help!

Ask Your Question

Weekly Poll