R
REGGIE
i have a spreadsheet with 3 non continuos ranges i'm
trying to use the =sumif function with.. it works with one
range..=SUMIF(Sheet1!$B8:$B158,1,Sheet1!E8:E158)
but if i try to use the non continuous ranges i
get "formula contains error"
= SUMIF(Sheet1!B8:B39,Sheet1!B50:B82,Sheet1!
B95:B127,1,Sheet1!E8:E39,Sheet1!E50:E82,Sheet1!E95:E127)
can anyone help ?
trying to use the =sumif function with.. it works with one
range..=SUMIF(Sheet1!$B8:$B158,1,Sheet1!E8:E158)
but if i try to use the non continuous ranges i
get "formula contains error"
= SUMIF(Sheet1!B8:B39,Sheet1!B50:B82,Sheet1!
B95:B127,1,Sheet1!E8:E39,Sheet1!E50:E82,Sheet1!E95:E127)
can anyone help ?