G
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
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