Excell
Solved/Closed
Carrie
-
Feb 9, 2010 at 10:02 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2010 at 02:59 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2010 at 02:59 PM
Related:
- Excell
- Excell download - Download - Spreadsheets
7 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2010 at 10:40 AM
Feb 9, 2010 at 10:40 AM
where you want to show the sum, use formula sum
Lets say, you want to add values from A1 to A4 from sheet2 to cell a1 in sheet 1, then in cell a1 of sheet write
=SUM(Sheet2!A1:A4)
Lets say, you want to add values from A1 to A4 from sheet2 to cell a1 in sheet 1, then in cell a1 of sheet write
=SUM(Sheet2!A1:A4)
When I use that formula, it also puts the formula on the second page in the same columns. I just need it only on the first page.
Do I have to have the info in the same place on both worksheets? or is there a way around this?
Do I have to have the info in the same place on both worksheets? or is there a way around this?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2010 at 11:56 AM
Feb 9, 2010 at 11:56 AM
No the formula is supposed to go to only place where you want to see the totals to show up. I am not sure why it would put the formula in both places. Could you put your file at some file sharing site like https://authentification.site
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2010 at 12:44 PM
Feb 9, 2010 at 12:44 PM
what cell are causing you issue
Didn't find the answer you are looking for?
Ask a question
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2010 at 02:10 PM
Feb 9, 2010 at 02:10 PM
well sorry I guess i am a bit thick headed here
But from what I understood
in Semi-Annual, cell g37, i see this formula =SUM(G9:G36)
you want to show this value on sheet Monthly Report on cell L14
in that case you would write in l14, ='Semi-Annual'!G37
But from what I understood
in Semi-Annual, cell g37, i see this formula =SUM(G9:G36)
you want to show this value on sheet Monthly Report on cell L14
in that case you would write in l14, ='Semi-Annual'!G37
No, that is what happened when I put the formula in the first tab..it just for some reason made them go to the second. any formula on that sheet is probably messed up.
What I need to know how to do is take the info from tab two and have it to put in tab 1. so in the spot for Elkhart for "other office expense", i need it to take the sum of all the "other office expense from tab two under Elkhart and put in in tab one's spot for Elkhart "other office expense"
What I need to know how to do is take the info from tab two and have it to put in tab 1. so in the spot for Elkhart for "other office expense", i need it to take the sum of all the "other office expense from tab two under Elkhart and put in in tab one's spot for Elkhart "other office expense"
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2010 at 02:27 PM
Feb 9, 2010 at 02:27 PM
The reason one thing would appear on other sheet is if both sheets are selected at the same time. You may have accidentally selected both sheets
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2010 at 02:59 PM
Feb 9, 2010 at 02:59 PM
No Problem. Just don't forget to vote democrat next election :P. Just kidding
