software

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)

quot;Patriciaquot; gt; wrote in message
...
gt; Is is possible to use sumif on one worksheet and then point to another
gt; worksheet within the same workbook?
gt;
gt; Example: sumif(Sheet1!A:A,A2,Sheet1!B:B)
gt;
gt; When I do this it does not give the correct sum and when you click in the
gt; 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 MVPquot;Patriciaquot; gt; wrote in message
...
gt; Is is possible to use sumif on one worksheet and then point to another
gt; worksheet within the same workbook?
gt;
gt; Example: sumif(Sheet1!A:A,A2,Sheet1!B:B)
gt;
gt; When I do this it does not give the correct sum and when you click in the
gt; formual the range and sum range both have #NUM next to it