Excell [Solved/Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
what cell are causing you issue
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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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
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"
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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
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!
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!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
No Problem. Just don't forget to vote democrat next election :P. Just kidding

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!