Sumif and Specified Ranges

[MstgSally]

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")

 

[Don Guillett]

What is your layout?

 

[ryguy7272]

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