View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MstgSally MstgSally is offline
external usenet poster
 
Posts: 1
Default 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")