| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating total in a range of numbers
I would like to calculate the sum of all values that are greater than 20 and
less 50 in the following data set. Can anyone give me the formula for this computation. 5 5 19 20 22 25 45 51 60 This is what I am after but with a larger data set. 20+22+25+45 = 112 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating total in a range of numbers
If, for example, your data is in column A, then
=sumif(a:a,"=20",a:a)-sumif(a:a,"50",a:a) should get it. BTW, this formula would INCLUDE the values 20 and 50 since your example included it in the sum. "Joe K" wrote: I would like to calculate the sum of all values that are greater than 20 and less 50 in the following data set. Can anyone give me the formula for this computation. 5 5 19 20 22 25 45 51 60 This is what I am after but with a larger data set. 20+22+25+45 = 112 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating total in a range of numbers
Assuming this range is in A1:A9 =SUMIF(A1:A9,"20")-SUMIF(A1:A9,"50") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=557489 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique RANDOM NUMBERS within specified range | Excel Worksheet Functions | |||
| Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
| how to get a total to add up a range | Excel Worksheet Functions | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Calculating a colmun to total a 40 hour work week | Excel Worksheet Functions | |||
Linear Mode
