COUNT IF

[PAL]

I am trying to count the number of rows if two parameters are met. I am
using this formula as an array. I get "0" returned and I know it is wrong.
Please advise. Thanks.

=COUNT(IF($F$2:$F$119="AAA",IF($D$2:$D$119="N",$D$2:$D$119,""),""))

 

[Gary''s Student]

Anytime you must deal with two or more criteria, consider SUMPRODUCT():

=SUMPRODUCT(($F$2:$F$119="AAA")*($D$2:$D$119="N"))

 

[John C]

You should use SUMPRODUCT
=SUMPRODUCT(--($F$2:$F$119="AAA"),--($D$2:$D$119="N"))

 

[Max]

Try:
=SUMPRODUCT(($F$2:$F$119="AAA")*($D$2:$D$119="N"))

Or, with TRIM for improved robustness:
=SUMPRODUCT((TRIM($F$2:$F$119)="AAA")*(TRIM($D$2:$D$119)="N"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[T. Valko]

Max, you're expertise is needed!

See the thread titled: Confusing Function by Chris C.

It's a few posts below this one (on CDO).