MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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 11:15 am
Countif
Posted : 03/11/2010 11:20 am
or sumif if you want to sum rather than count
Posted : 03/11/2010 11:23 am
=COUNTIF(A1:A5,">.85")
Posted : 03/11/2010 1:29 pm