Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 2,069

SUMIF ranges

-- In a SUMIF statement how do you write the range and sum_range portions to
include two ranges, one range from sheet 1 and one range from sheet 2?

=SUMIF(Sheet1!B20:B39,"<999",Sheet1!E20:E39) works fine for Sheet1, but I
can not get
=SUMIF(Sheet1!B20:B39,'Sheet2!B3:B49',"<999",Shee t1!E20:E39,'Sheet2!E3:E49')
to include the range or sum_range from sheet two.

Thanks John

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 Using Date ranges	Rita Palazzi	Excel Discussion (Misc queries)	3	May 31st 07 08:11 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 Multiple Ranges	Erika	Excel Worksheet Functions	2	April 28th 05 05:40 PM
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 09:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us