Posted by JessNC on 1/3/07 10:27am
Msg #168823
Can anyone help me w/an Excel issue, please? Ndwa?
I have really tried to figure this out on my own, but I cannot...and I know there's got to be a way...
Last year, I got a great Excel spreadsheet from Andy that helped me track my signings. I tweaked it a little for my own needs and everything seemed okay, until i realized that the sheets aren't totaling to the main page...the original ones are, but not the ones I copied and renamed. I just can't figure out how to get the totals on each page and have it automatically add up again on the summary page.
Am I making sense or do I just sound like a total idiot?!
I appreciate any help or suggestions anyone has...Thanks so much!
|
Reply by TRG_wy on 1/3/07 10:50am
Msg #168827
OK - If you are trying to get the SUM total to show on sheet one that includes a sum total from sheet two as well.
Example:
=SUM(X243+IncomeExpense_2006!M211)
Where X243 is my total sum on sheet one then I add the results of a total from sheet two (my sheet name here is IncomeExpense_2006) and the total is in cell M211.
To do it automatically: type "=sum(" then click on the cell you want to sum, then type "+", then goto sheet two and click on the cell with the total that you want to add. Then type your closing bracket " ", end Enter. Dont' type the " in my example.
|
Reply by PL on 1/3/07 10:52am
Msg #168828
I believe you are talking about the autosum (odd looking E, 14 positions down on the tool bar)
If you will pick a row and column you want to add, then hit the (odd e) and drag the blue box up the column you want to add. You will see that all the figures in the column will total. Good luck
|
Reply by JessNC on 1/3/07 11:09am
Msg #168833
Think I really messed up my summary sheet....
Thanks so much for your help! That makes sense - but when I looked at it again, I think my problem may the actual summary sheet...
Instead of showing all the sheets that I copied (which I did because I had more than 25 companies to track-but I think this is where I goofed to begin with), it just shows the first 24 and then after that it is blank...how do I link the sheets I have already established, but are not showing on this sheet? I guess I have to add them manually to the summary sheet but I am not sure how to do this (without messing up even more!)...
|
Reply by Art_MD on 1/3/07 11:27am
Msg #168838
Re: Think I really messed up my summary sheet....
lets name your sheets sheet1,sheet2 ,sheet33 .....sheet50
If you want to total the value of g6 on page 1 + g6 on page 2 + g6 on page 3 etc, into g7 on page one, the formula in g7 would be:
=+g6+sheet2!g6+sheet3!g6+sheet4!g6......sheet50!g6
Hope this helps
Art
|
Reply by JessNC on 1/3/07 12:26pm
Msg #168854
Thank you everyone & THANK YOU ANDY!!!
Thank you for all your help! Andy called me and helped fix everything!!! Thank you!
NotRot is awesome! 
|
Reply by Ndwa on 1/3/07 1:14pm
Msg #168859
You're welcome! n/m
|
Reply by Mia on 1/3/07 12:37pm
Msg #168856
You can always go to......
You can always find great answers (or get answers) regarding Excel at
http://www.mrexcel.com/
There is a message board - and people are very quick with with the answers.
Hope this helps.
|
Reply by Ernest__CT on 1/4/07 8:26am
Msg #168981
Bless you, Mia! Great Excel stuff! n/m
|
Reply by TitleGalCA on 1/3/07 3:11pm
Msg #168883
Try this link:
http://office.microsoft.com/en-us/excel/HP101023381033.aspx?pid=CH100648441033
Good luck.
|
