Topic starter
i have a list of perecntages in a column (about 200) and i need to be able to give a total at the bottom of the number of entreis that are above 85% is there a formula i an use that will do that and give me a total
cheers
Posted : 03/11/2010 12:15 pm
Countif
Posted : 03/11/2010 12:20 pm
or sumif if you want to sum rather than count
Posted : 03/11/2010 12:23 pm
=COUNTIF(A1:A5,">.85")
Posted : 03/11/2010 2:29 pm