sumif within a range

  • Thread starter Thread starter que777
  • Start date Start date
Q

que777

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
 
Back
Top