Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum within a range of numbers
I have a long list of numbers that ranges from 680,608.60 to 131.06.
I need to sum only those within 50,001 and 200,000. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum within a range of numbers
=SUMIF(A:A,"=50001")-SUMIF(A:A,"200000")
Vaya con Dios, Chuck, CABGx3 "Luis" wrote in message ... I have a long list of numbers that ranges from 680,608.60 to 131.06. I need to sum only those within 50,001 and 200,000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying numbers stored in a range??? | Excel Discussion (Misc queries) | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
get a count of numbers whose value falls within a given range | Excel Worksheet Functions | |||
Find Median of Positive numbers only in Range | Excel Worksheet Functions |