formula to count cells containing #'s in a specific range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this is going to be an easy answer nut I just cant figure it out...
How do I count a cell that is greater than a specific and less than a
another specific number....or to count it if it contains a number in a
specific range?
 
Use COUNTIF():

=COUNTIF(A1:A10,">3")-COUNTIF(A1:A10,">7")

will count the number of cells with value greater than 3 and less than 7
 
You must log in or register to reply here.

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

How do I count cells that contain a number of charctors. 3
Count the times a specific character appears in a cell 3
Excel Need Countifs Formula Help 0
subtract one cell from each cell in a range and count instances 2
count - but exclude counting cells with a formula 4
Excel Count Cells That Contain Text With "?" 0
Counting a range of cells 2
Excel Formula 2

Back
Top