Excel 2003 - Counting Contents of Cells

  • Thread starter Thread starter nick_crocker
  • Start date Start date
N

nick_crocker

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.
 
=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)
 
Back
Top