Checking if values are between values

  • Thread starter Thread starter guilbj2
  • Start date Start date
G

guilbj2

I'm having a little trouble getting a formula to work. All I need to d
is use Countif to determine whether or not a value is within a certai
range (1.0-1.9).

The formula I've tried is:

=countif(a1:a25,>1.0<1.9)

I'm sure there's something wrong since it's not working, but hopefull
someone can advise me on the correct syntax.

This worksheet is being created with Excel 97
 
Hi
COUNTIF only accepts one condition try
=SUMPRODUCT(--(A1:A25>1.0),--(A1:A25<1.9))

or in your case you may use
COUNTIF(A1:A25,"<1.9") - COUNTIF(A1:A25,"<=1.0")
 
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

countif, multiple value range PLEASE HELP 2
Using COUNTIF with AND 5
Excel - count if a number falls within an array in a column & add 3
Conditional Formatting Minimim Value 2
Scrabble Value calculation for Welsh words 0
Drop down and cell values 2
COUNTIF between dates and if value = "y" 8
Range Formula 7

Back
Top