formula help

[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 ?

 

[Ross Hodges]

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 ?

See if you can find another function that does what you need. I don't know
if SUMIF can do this. Does anybody else know?

(e-mail address removed)

 

[Frank Kabel]

Hi
just use three SUMIF statements. e.g.
=SUMIF(Sheet1!B8:B39,1,Sheet1!E8:E39) +
SUMIF(Sheet1!B50:B82,1,Sheet1!E50:E82) +
SUMIF(Sheet1!B95:B127,1,Sheet1!E95:E´127)