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!

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

THANK YOU! =0)

you don't how many times i tried something.

"Bob Phillips" wrote:

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

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!

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!