sumif within a range
 

I have used the sumif function to calculate an answer if the data is less
than or greater than a certain value, however want to calculte an answer if
the data is within a range. Eg. I know how to calculate the following; If
value in A1 than 5 then sum value of A2. I want to calculate the following
but don't know how; If value in A1 is between 2 and 5 sum value of A2

sumif within a range
 

One way:

=If(And(A1=2,A1<=5),A2,"")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"que777" wrote in message
...
I have used the sumif function to calculate an answer if the data is less
than or greater than a certain value, however want to calculte an answer
if
the data is within a range. Eg. I know how to calculate the following;
If
value in A1 than 5 then sum value of A2. I want to calculate the
following
but don't know how; If value in A1 is between 2 and 5 sum value of A2