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

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Patricia" wrote in message
...
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

Patricia,

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

worked perfectly for me.

HTH,
Bernie
MS Excel MVP


"Patricia" wrote in message
...
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