Excel Count Formula

April 4, 2011 at 12:10:04
Specs: Windows XP
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


See More: Excel Count Formula

Report •


#1
April 4, 2011 at 12:11:43
If you have 2007 look at the =COUNTIFS() (note the S at the end) function.

MIKE

http://www.skeptic.com/


Report •

#2
April 4, 2011 at 12:12:51
Sadly no, I have 2003 still

Report •

#3
April 4, 2011 at 13:02:29
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

http://www.skeptic.com/


Report •

Related Solutions

#4
April 5, 2011 at 08:54:57
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!


Report •

#5
April 5, 2011 at 11:50:03
Nope, it didn't work,

In what way did it not work?

MIKE

http://www.skeptic.com/


Report •

Ask Question