Previous Topic Next Topic

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
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.
Related:

7 responses

Answer 1 / 7
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Answer 2 / 7
Carrie
Feb 9, 2010 at 11:50 AM
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
Answer 3 / 7
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Answer 4 / 7
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2010 at 12:44 PM
what cell are causing you issue
0
Carrie
Feb 9, 2010 at 01:06 PM
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
Answer 5 / 7
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Carrie
Feb 9, 2010 at 02:14 PM
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
Answer 6 / 7
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Carrie
Feb 9, 2010 at 02:55 PM
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
Carrie
Feb 9, 2010 at 02:55 PM
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
Answer 7 / 7
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2010 at 02:59 PM
No Problem. Just don't forget to vote democrat next election :P. Just kidding
0