Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula assistance please???
Friends,
I'm looking for a formula to use in Excel 2003. I need to sum the figures that are greater than 500k but less than 1.5M in a data range in another sheet. Can anyone help? need quickly please... -- Kimmie_C |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula assistance please???
Maybe
=SUMIF(Sheet2!A1:A19,"500000")-SUMIF(Sheet2!A1:A19,"=1500000") Mike "Kimmie_C" wrote: Friends, I'm looking for a formula to use in Excel 2003. I need to sum the figures that are greater than 500k but less than 1.5M in a data range in another sheet. Can anyone help? need quickly please... -- Kimmie_C |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula assistance please???
I'll try it, but would it subtract using the - sign instead of adding them
all together? -- Kimmie_C "Mike H" wrote: Maybe =SUMIF(Sheet2!A1:A19,"500000")-SUMIF(Sheet2!A1:A19,"=1500000") Mike "Kimmie_C" wrote: Friends, I'm looking for a formula to use in Excel 2003. I need to sum the figures that are greater than 500k but less than 1.5M in a data range in another sheet. Can anyone help? need quickly please... -- Kimmie_C |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula assistance please???
Yes, that is his intents.
All values greater than 500,000 include all values greater than 1,500,000, therefore, once you get a sum of all values greater than 500,000, you need to eliminate the portion of those values greater than 1,500,000. -- John C "Kimmie_C" wrote: I'll try it, but would it subtract using the - sign instead of adding them all together? -- Kimmie_C "Mike H" wrote: Maybe =SUMIF(Sheet2!A1:A19,"500000")-SUMIF(Sheet2!A1:A19,"=1500000") Mike "Kimmie_C" wrote: Friends, I'm looking for a formula to use in Excel 2003. I need to sum the figures that are greater than 500k but less than 1.5M in a data range in another sheet. Can anyone help? need quickly please... -- Kimmie_C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula assistance | Excel Discussion (Misc queries) | |||
Formula Assistance | New Users to Excel | |||
Assistance with Formula | Excel Worksheet Functions | |||
Assistance with Formula | Excel Worksheet Functions | |||
Formula Assistance | Excel Discussion (Misc queries) |