Hi,

Am Mon, 20 Feb 2012 08:44:46 -0800 (PST) schrieb foofoo:

1. The number of times a manager's name shows up in Column B and the
number of non blank cells in column G.
2. The number of times a manager's name shows up in Column B and the
number of blank cells in column G.

1. =SUMPRODUCT((B2:B100="Manager 1")*(G2:G100<""))
2. =SUMPRODUCT((B2:B100="Manager 1")*(G2:G100=""))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2