Formula's

B

Barb

I am trying to do a count series between 0-100. 1st
count =COUNTIF(G4:K22,">89.99") is effective. 2nd count
between 80.0 and 89.98 is not working. 3rd count =COUNTIF
(G4:K22,"<79.99") is effective.
Could anyone help me with the formula I should be using
for the second count? Thanks
 

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 0
Count formulas 2
Excel Formula 2
Counting occurences of text 3
countifs Function not giving desired result with date criteria 2
COUNTIFS with No Criteria 1
using CountIF function or Array? 3
Multi-demensional frequency distribution 4

Top