- how to sumif values between certain numbers
- algebra problems
Please log in or register to add a comment.
Your answer.
You need the SUMIFS function which allows you to specify more than one condition.
For example: SUMIFS(B2:B10,B2:B10,">=24",B2:B10,"<=32")
or SUMIFS(B2:B10,B2:B10,">24",B2:B10,"<32").
This sums the cells B2 to B10 if the values lie between 24 and 32 (inclusive) or 24 and 32 (exclusive). You can add other arguments if you're summing values in a different column. Use Excel Help to use other forms of SUMIFS and experiment so that you get the correct format. SUMIF allows you to sum values in a different column to the one you're applying a condition. SUMIFS allows you to do this, too: SUMIFS(A2:A10,B2:B10,">=24",B2:B10,"<=32"). The sums are done for cells A2 to A10 using the criteria in B2 to B10 (values between 24 and 32).
Hope this helps.
Related questions
- word problems
- a. show that the probabilities above form a proper probability distribution.
- trigonometric functions
- thanks a lot.
- rounding numbers
- solving equations
- dividing decimals
- place value
- normal distribution
- calculus problems
- trigonometry problems
- trig equations
- average rate of change
Most popular questions within the last 3000 days
- 50+50-25X0+2+2= (19)
- it takes 10 road workers 5 days to complete a road repair when working 2 hours a day.Working at the same pace,how many days will it take 2 people working 5 hours a day to finish it? (3)
- complete the following. 825 use each digit once .make the two smallest 3 digit numbers and two largest 3-digit number (2)
- Solve 15 -1(12÷4+1)? (4)
- 8:4(5+2) (3)
Most popular tags
IMAGES