Excell Newbie Question Please Help
 

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

Excell Newbie Question Please Help
 

Hi,

The first formula does not have to be an array formula and you change it
like shown below

=SUMIF(J2:J8,"A",I2:I8)+M45

The second formula will become

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

Is that what you wanted to do?

Alok Joshi
"KeyWest JetSki" wrote:

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