How to COUNTIF in between two percentages

A

Ali

Would anyone mind taking the time to give me step by step directions do this?:
I have to figure out a function to count the number of marks on a previous
sheet that are between 50% and 90%. All the grades are in % and they have to
go into a chart on the next sheet.

Thanks so much!
 
A

Ali

Thnks Val, that's very helpful!!!

Val said:
Ooh, this was a fun one to reasearch.

Found the basic info you need at:
http://www.ozgrid.com/Excel/arrays.htm

In your case, the formula should be something like:
=SUM(IF(A1:A11>=0.5,IF(A1:A11<=0.9,1,0),0))

(substitute your cell references) and the big trick is, when you've typed
the formula, press Ctrl+Shift+Enter to close the editing.
You must press this sequence to end any future editing of the formula, as
well.

Val
Click to expand...
 
Top