I have a spreadsheet with two worksheets that total columns for daily sales.
I would like to add the totals from both worksheets on one worksheet. I cut
& paste useing the the link paste option to get the results of worksheet #2
into worksheet #1 But I cannot figure how to add the totals to my existing
formulas.

I pasted the totals from worksheet #2 into cell M45
My existing formaulas are

{=SUMIF(J2:J38,"A",I2:I38)}

{=SUM(IF((J2:J38="V")+(J2:J38="M"),I2:I38))}

How do I add M45 to the existing formulas?


Thanks

Tom