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

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History