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

--
__________________________________
HTH

Bob

"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!