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