Count function problem

[Christo]

Hi there,

I need the formula to count how many reps I have on my
spreadsheet i.e.

Jones
Jones
Roberts
Doe
Albert

The # of reps should be 4.....

Please help!!!!

Thanks

 

[Frank Kabel]

Hi Christo
if you have no blanks in that columns try
=SUM(1/COUNTIF(A1:A100,A1:A100))

Frank

 

[Andy B]

Christo

This needs to be array-entered (instead of hitting Enter when you've done
it, hit Ctrl Shift and Enter)

Andy.

 

[Guest]

Hi Frank,

Thanks for the response, i tried this but it does not
work, the value of the formula below is 0. I am using
excel 2003 if this makes a difference...

 

[Frank Kabel]

Hi
forgot to mention you have to array enter this formula
(CTRL+SHIFT+ENTER instead of only hitting ENTER)

Frank

 

[Harlan Grove]

forgot to mention you have to array enter this formula
(CTRL+SHIFT+ENTER instead of only hitting ENTER)

You should have used SUMPRODUCT.

=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

doesn't need to be entered as an array formula.

 

[Frank Kabel]

...

You should have used SUMPRODUCT.

=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

doesn't need to be entered as an array formula.

Harlan
thanks, good point
Frank