Count specific text only if adjacent cell is blank?

  • Thread starter Thread starter rumtumtigger
  • Start date Start date
R

rumtumtigger

Hi all,
I have a spreadsheet with several different employee initials in one cell
and sometimes assistant name in the next cell if someone helped them on a
project. I want to count the cells of the employee BP only if the cell next
to it is blank and they managed the project themselves. Then I want to go to
a different totals cell and put in a formula to count employee RS who managed
the project alone... etc. etc.
I tried using IFBLANK but I am a bit of a novice can't quite figure this
out! Any help would be appreciated!
 
Hi

With Employee initials in column A, assistants in column B, and BP (the
employee to calculate total for) in C2 insert this formula in D2:

=SUMPRODUCT(--($A$2:$A$100=C2),--($B$2:$B$100=""))

Regards,
Per
 

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Blank Cell Oddity 2
Count Formulas 1
Count with merged cells 2
Data Validation-Only allow entry into cell if adjacent cell is fil 2
If cell is blank automatically enter today's date in the same cell 21
Count of visible, non-blank cells only? 8
counting colored cells 3

Back
Top