=SUMPRODUCT(--(A1:A100="RS")*(B1:B100=""))

or something similar
--
Gary''s Student - gsnu201001


"rumtumtigger" wrote:

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!