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 |
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 |
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 |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com