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.

--
Thanks,
Shane Devenshire


"Jill V" wrote:

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!