sumif within a range

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
 

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

Top