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

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

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

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