Row count

[Andrew]

Hi,

I have a row consisting of a number of percentages, and I want a cell at
the end of the row to display the number of cells that are greater than
100% eg:

56% 45% 76% 109% 34% 156% 12% 2

Does anyone here smarter than me know how do do this in excel?

Thanks

 

[JulieD]

Hi Andrew

not sure about the smarter bit ... just played with this before

=COUNTIF(A1:A9,">"&100%)

Cheers
JulieD

 

[L. Howard Kittle]

Hi Andrew,

=COUNTIF(A1:G1,">100%")

Works also.

HTH
Regards,
Howard