Posted to microsoft.public.excel.worksheet.functions

MstgSally

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SumIf and ranges	Katie	Excel Worksheet Functions	2	May 12th 08 11:14 PM
SUMIF ranges	John	Excel Worksheet Functions	2	September 24th 07 03:54 PM
SUMIF using two ranges	yvonneb	Excel Discussion (Misc queries)	3	May 31st 07 12:46 PM
How to SUMIF multiple ranges?	karesz	Excel Discussion (Misc queries)	1	November 10th 05 12:34 AM
SUMIF and 3-D Ranges	Ron In Tulsa	Excel Worksheet Functions	2	November 22nd 04 07:30 PM

All times are GMT +1. The time now is 06:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us