Count function problem

  • Thread starter Thread starter Christo
  • Start date Start date
C

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
 
Hi Christo
if you have no blanks in that columns try
=SUM(1/COUNTIF(A1:A100,A1:A100))

Frank
 
Christo

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

Andy.
 
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...
 
Hi
forgot to mention you have to array enter this formula
(CTRL+SHIFT+ENTER instead of only hitting ENTER)

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

You should have used SUMPRODUCT.

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

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

You should have used SUMPRODUCT.

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

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

Harlan
thanks, good point
Frank
 
Back
Top