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
 
Back
Top