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

"Jill V" <Jill wrote in message
...
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!