Formula for countif two criteria - Excel 2003

February 25, 2011 at 01:51:41
Specs: Windows XP

I working with Excel 2003. I am trying to create a formula which will count on two criteria. Basically in the example attached I am trying to count the number of times that "Not recorded" shows for the "AMS" column. Any help would be appreciated.

Col A Col B Col C
Name 1 Not recorded AMS
Name 2 Not recorded AMS
Name 3 Not recorded AMS
Name 4 Not recorded BCG
Name 5 Not recorded BCG

See More: Formula for countif two criteria - Excel 2003

Report •

February 25, 2011 at 09:31:34
=SUMPRODUCT(($B$1:$B$5="Not recorded")*($C$1:$C$5="AMS"))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question