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