formula help

  • Thread starter Thread starter REGGIE
  • Start date Start date
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 ?
 
REGGIE said:
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 ?
Click to expand...

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)
 
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)
 
Back
Top