How do I count the items in one column if another column is blank

D

dereksmom

I am looking for an excel formula that would capture the counts of one column
(column A, that contains text and/or number) when the cells in another column
(column B) is blank. Any help would be great. Thanks!
 
B

Bob Phillips

=SUMPRODUCT(--(A1:A1000<>""),--(B1:B1000=""))

--
HTH

Bob Phillips

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