R
REGGIE CARSON
i have a speadsheet i'm working on that has three separate
areas of data on sheet one...on sheet two i have an area
to compile results of formulas..my proplem is with =sumif
= SUMIF(Sheet1!B8:B39,1,Sheet1!E8:E39)
i have non continuos ranges for my range and sum range..
the formula works with a single range put when i try to
put in my other non continuos ranges i get "formula
contains an error"
= SUMIF(Sheet1!B8:B39,Sheet1!B50:B82,Sheet1!
B95:B127,1,Sheet1!E8:E39,Sheet1!E50:E82,Sheet1!E95:E127)
areas of data on sheet one...on sheet two i have an area
to compile results of formulas..my proplem is with =sumif
= SUMIF(Sheet1!B8:B39,1,Sheet1!E8:E39)
i have non continuos ranges for my range and sum range..
the formula works with a single range put when i try to
put in my other non continuos ranges i get "formula
contains an error"
= SUMIF(Sheet1!B8:B39,Sheet1!B50:B82,Sheet1!
B95:B127,1,Sheet1!E8:E39,Sheet1!E50:E82,Sheet1!E95:E127)