Excel Formula

B

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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count formulas 2
Formula's 0
COUNTIF Cells in Range? 4
Urgent Need help 4
Count Formulas 0
Counting formula help needed! 2
Excel Conditional Formatting for Percentagrs 0
Countif formula between numbers 3

Top