SUMIF across worksheets

[Guest]

Is is possible to use sumif on one worksheet and then point to another
worksheet within the same workbook?

Example: sumif(Sheet1!A:A,A2,Sheet1!B:B)

When I do this it does not give the correct sum and when you click in the
formual the range and sum range both have #NUM next to it

 

[Bob Phillips]

Works fine here, sound like you have some error in the data


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bernie Deitrick]

Patricia,

=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)

worked perfectly for me.

HTH,
Bernie
MS Excel MVP