Excell

Solved/Closed
Carrie - Feb 9, 2010 at 10:02 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 9, 2010 at 02:59 PM
Hello,

I need a formula that will take the sum of a group of cells from a worksheet and apply them to a specific place on another worksheet. All in the same workbook.

I tried doing this put it ended up putting the sum in various places on both worksheets.

7 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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)
1
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?
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Feb 9, 2010 at 12:44 PM
what cell are causing you issue
0
Any that I put the formula in. an example is when I do the Other office Expense and try to put that formula there to pick it up on the 2nd tab the semi annual, for the same county it puts the formula on the same rows/columns that i put the formula in on the first page.
0

Didn't find the answer you are looking for?

Ask a question
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0
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"
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0
That could be a possibility... I could have been holding down control when I moved to the next page, not thinking. Thanks for your help I really appreciate it!
0
That could be a possibility... I could have been holding down control when I moved to the next page, not thinking. Thanks for your help I really appreciate it!
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Feb 9, 2010 at 02:59 PM
No Problem. Just don't forget to vote democrat next election :P. Just kidding
0