Count

C

Clueless

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)
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

Clueless

Thank you! That worked perfectly.

Bob Phillips said:
=SUMPRODUCT(--(I2:I200<>""),--(D2:D200="A"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Top