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