Hi,

For the preisdent you could use

=COUNTA(B2:B14)

For thother put this in C3 and drag down
=COUNTIF(B$2:B$14,"="&A3)

Mike

"FARAZ QURESHI" wrote:

I have two columns as follows
A B
Officer Reporting To
President
VP-1 President
VP-2 President
VP-3 President
AVP-1 VP-1
AVP-2 VP-1
AVP-3 VP-1
AVP-1 VP-2
AVP-2 VP-2
AVP-3 VP-2
AVP-1 VP-3
AVP-2 VP-3
AVP-3 VP-3

How can I insert a formula in "C:C" to check out the number of total
juniors, i.e.:
1. President has span over all the staff, column C should be reflecting
"12". Each Vice President (VP) has "3" sub-ordinates and the Assistant Vice
Presidents (AVPs) have "0" subordinates.

Please help me out at the earliest.

Thanx in advance