Row count

A

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
 
J

JulieD

Hi Andrew

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

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

Cheers
JulieD
 
Top