Excel Formula

[Barb]

I am trying to format spreadsheet. Need 3 counts. 1st
count is for 90% and above =COUNTIF(H5:M16,">89.99").
Second count is for Under 80% =COUNTIF
(H5:M16,"<79.99") . Can anyone help me with a formula for
3rd count, between 80% and 89.98? I can't seem to
formulate it. Thanks in advance

 

[Bob Phillips]

Hi Barb,

Try

=COUNT(H5:M16) - COUNTIF(H5:M16,">89.99") - COUNTIF(H5:M16,"<79.99")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jerry W. Lewis]

=COUNTIF(H5:M16,">79.99")-COUNTIF(H5:M16,"<89.99")

Jerry