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

"rumtumtigger" skrev i meddelelsen
...
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!