formula help

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

Ross Hodges

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 ?

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)
 
F

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top