Formula assistance please???

  • Thread starter Thread starter Kimmie_C
  • Start date Start date
K

Kimmie_C

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...
 
Maybe

=SUMIF(Sheet2!A1:A19,">500000")-SUMIF(Sheet2!A1:A19,">=1500000")

Mike
 
I'll try it, but would it subtract using the - sign instead of adding them
all together?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater Than Symbols and calculations 0
Excel Need Countifs Formula Help 0
Excel Formula or equation 3
Sumif number is greater than a number but less than another number 2
Complex formula help , please. 13
need formula help 6
Excel Formula Help 5
How to create a formula with multiple (IF) conditions 3

Back
Top