Sumif and Specified Ranges
 

How would I sum a column of numbers, based on the following ranges:

1. 0 - 2500
2. 2501 - 5000
3. 5001 - 10000
4. 10001 - 15000
5. 15001 - 20000
6. 20000+

For example: the formula would sum all numbers that fall within one of the
ranges above.

I've tried the following formula based on the #2 range above:
=SUMIF('Sheet1!$B$3:$B$33,"2501"&"<5000")

Sumif and Specified Ranges
 

What is your layout?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MstgSally" wrote in message
...
How would I sum a column of numbers, based on the following ranges:

1. 0 - 2500
2. 2501 - 5000
3. 5001 - 10000
4. 10001 - 15000
5. 15001 - 20000
6. 20000+

For example: the formula would sum all numbers that fall within one of the
ranges above.

I've tried the following formula based on the #2 range above:
=SUMIF('Sheet1!$B$3:$B$33,"2501"&"<5000")

Sumif and Specified Ranges
 

Is there more to this? I don't think you want to sum ranges. Take a look at
this:
http://www.xldynamic.com/source/xld....T.html#classic

Right at the bottom of the page is a function such as this:
=SUMPRODUCT((A1:A10=10)*(A1:A10<=20))

I think that should get you going...

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"MstgSally" wrote:

How would I sum a column of numbers, based on the following ranges:

1. 0 - 2500
2. 2501 - 5000
3. 5001 - 10000
4. 10001 - 15000
5. 15001 - 20000
6. 20000+

For example: the formula would sum all numbers that fall within one of the
ranges above.

I've tried the following formula based on the #2 range above:
=SUMIF('Sheet1!$B$3:$B$33,"2501"&"<5000")