Count
 

Not too good with formulas & need help. Column "D" has either an A or B in
it. Column "I" has a date. What I need the formula to do is if there is a
date in column "I" then give me the total # of A's and total # of B's from
column "D".

I've tried this but it doesn't work: =count(d17:d338,"a")if(i17:i338)

Count
 

=SUMPRODUCT(--(I2:I200<""),--(D2:D200="A"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Clueless" wrote in message
...
Not too good with formulas & need help. Column "D" has either an A or B
in
it. Column "I" has a date. What I need the formula to do is if there is
a
date in column "I" then give me the total # of A's and total # of B's from
column "D".

I've tried this but it doesn't work: =count(d17:d338,"a")if(i17:i338)

Count
 

Thank you! That worked perfectly.

"Bob Phillips" wrote:

=SUMPRODUCT(--(I2:I200<""),--(D2:D200="A"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Clueless" wrote in message
...
Not too good with formulas & need help. Column "D" has either an A or B
in
it. Column "I" has a date. What I need the formula to do is if there is
a
date in column "I" then give me the total # of A's and total # of B's from
column "D".

I've tried this but it doesn't work: =count(d17:d338,"a")if(i17:i338)