Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF ranges
=SUMIF(Sheet1!B20:B39,"<999",Sheet1!E20:E39)
+SUMIF('Sheet2!B3:B49',"<999",'Sheet2!E3:E49') -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "John" wrote in message ... -- 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF ranges
Why not just use 2 SUMIF(...), one per sheet, then add them up?
: =SUMIF(...)+SUMIF(...) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John" wrote: -- 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif Using Date ranges | Excel Discussion (Misc queries) | |||
SUMIF using two ranges | Excel Discussion (Misc queries) | |||
How to SUMIF multiple ranges? | Excel Discussion (Misc queries) | |||
SumIF Multiple Ranges | Excel Worksheet Functions | |||
SUMIF and 3-D Ranges | Excel Worksheet Functions |