COUNTIF Help

[Jason B]

Example:
Average
10 5 6 4 3 7 5 8 6
I want to be able to use a countif function to tell me the
amount of occurences that are greater than the average and
less than the average. I can get the countif function to
work as e.g. COUNTIF(A1:A8,">6") which returns 3, but
instead of ">6" I want to be able to reference it to a
specific cell as in ">A8" but this does not work. Any help
gratefully appreciated.
Thanks in advance
Jason.

 

[Frank Kabel]

Hi Jason
try
COUNTIF(A1:A8,">" & A8)

 

[Peo Sjoblom]

Try


COUNTIF(A1:A8,">"&A8)

 

[Guest]

Works a treat, thanks a lot.

-----Original Message-----
Try


COUNTIF(A1:A8,">"&A8)
--

Regards,

Peo Sjoblom




.

 

[damonh]

Hi,

You need to use the &, this lets you mix strings and cell
references. SO in your example if you wanted to see how
many in your range where greater than the value in cell
A8, you would type: =COUNTIF(A1:A7,">="&A8)

Hope that helps