On Mon, 20 Feb 2012 12:20:52 -0500, Ron Rosenfeld wrote:

For Manager 1, I need to know how many non blank cells are in column G

=SUMPRODUCT(($B:$B="Manager 1")*($G:$G<""))


(there are 2) and how many blank cells are in column G (there is 1)

=SUMPRODUCT(($B:$B="Manager 1")*($G:$G=""))

I forgot you are using Excel 2003. That precludes referencing a full column in an array formula; so the above ranges need to be changed from

$B:$B and $G:$G to
=$B$2:$B$max_row_num and =$G$2:$G$max_row_num where max_row_num is the highest row number you might encounter (and could be 65536).