COUNTIF Function

[Jill V]

I have a spreadsheet with the following information:

Active? Type
Y GI
N AD
Y AD
N GI

I need to count how many AD with Y are in the sheet. Would I be using a
COUNTIF, DCOUNTA, or something else entirely? Please help!

 

[Bob Phillips]

=sumproduct(--(A2:A20="Y"),--(B2:B20="AD"))

 

[Jill V]

THANK YOU! =0)

you don't how many times i tried something.

 

[ShaneDevenshire]

Hi Jill,

You weren't on the wrong track! DCOUNT would have worked also, the formula
is simplier, but you need a criteria range in the spreadsheet.

Also, in 2007 you could have used the new function COUNTIFS notice the S on
the end, it allows multiple criteria.

 

[Ashish Mathur]

Hi,

You could also try the following array formula (Ctrl+Shift+Enter)

SUM(IF((A11:A14="Y")*($B$11:$B$14="AD"),1))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com