Checking if values are between values

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
 
F

Frank Kabel

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")
 

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
Counting the number of unique values within a range 5
Finding the weighted average of text that have been given values 1
Excel - count if a number falls within an array in a column & add 3
sum if - null values 1
Using COUNTIF with AND 5
Range Formula 7
compare values 10

Top