Excell Newbie Question Please Help

K

KeyWest JetSki

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Newbie Question Please Help 4
How can I format the last row ! 5
Need help with formula 8
Code For Copy Copies Twice 3
Help: Macro Adds Rows, Need to Update Totals with New rows 2
Time punch & hours calculations 1
Volitile Formula 1
Excel Excel Formula OFFSET maybe? 1

Top