Excel 2003 - Counting Contents of Cells
 

Hi, have a list of about 100 different consultants, all named, in a
list of their time over a three month period (i.e there about 5-15
lines/entries per consultant. I need to know exactly how many
consultants I have, but don't want to count them all manually. Is
there a way I can count them using a formula?

Many thanks,
Nick.

Excel 2003 - Counting Contents of Cells
 

=SUMPRODUCT((A2:A200<"")/COUNTIF(A2:A200,A2:A200&""))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
ups.com...
Hi, have a list of about 100 different consultants, all named, in a
list of their time over a three month period (i.e there about 5-15
lines/entries per consultant. I need to know exactly how many
consultants I have, but don't want to count them all manually. Is
there a way I can count them using a formula?

Many thanks,
Nick.