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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=SUMPRODUCT(--(A1:A1000<>""),--(B1:B1000=""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Hide columns based on row values 2
Counting NON-Blank fields 2
Count the columns from one sheet and paste it in another sheet 0
Counting in multiple column 2
Excel Average dates help 0
How to count merged cells 1

Back
Top