Hello -

I am using Excel 2003. I need to use an array formula to determine
the following 2 conditions:

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.

An example of my data is:
Manager (column B) Date Trng Comp (column G)
Manager 1 02/08/12
Manager 2 02/09/12
Manager 3
Manager 2 02/01/12
Manager 1
Manager 1 02/02/12

For Manager 1, I need to know how many non blank cells are in column G
(there are 2) and how many blank cells are in column G (there is 1)

Thanks