Forum Discussion
Need help with formula
Damien,
Thank you so much. I now might get done before midnight MST.
I was in your city 25 years ago. We had a great time.
Blessings,
Steve
Hi Steve
Try this:
=Sheet1!G6
If necessary, change Sheet1 to whatever the source sheet is called that has your value for G6. You can copy and paste the formula to the other 6 sheets.
If you want to apply it yourself manually where G6 is on every sheet (good practice):
1. Go into the sheet (one of your 6) where you want the G6 value to appear.
2. Type = into the desired cell where you want the G6 value to show.
3. Click onto the source sheet where G6 value is located, click onto cell G6.
4. Press Enter.
You'll see that the formula updates as you do these steps.
Anyway either method will work. Hope that is what you are looking for.
Good luck!
Cheers
Damien
Thanks, but it show an error.
Sheet 1 cell G6 is where I want the sum of sheets 2-7 cell G6. Can you help?
Hi Steve
Sorry I get you now, I read your first post as wanting to have G6 on every sheet, you are asking to SUM up G6 from the 6 sheets and have the result on Sheet1.
Try this:
=SUM(Sheet2!G6,Sheet3!G6,Sheet4!G6,Sheet5!G6,Sheet6!G6,Sheet7!G6)
I've also attached the workbook I made to demo this.
Let me know how you go?
Cheers
Damien
Damien,
Thank you for your help. I enter this formula on my control sheet and it didn't add the 6 sheets to the control sheet.
=SUM('1'!G6, '2'!G6, '3'!G6, '4'!G6, '5'!G6, '6'!G6)
What am I doing wrong?
Steve
Damien
I've attached my file. If you could do the SUM for cell G6 on Combined Budget I should be able to copy the formula to other cell. Thanks for your help.
Steve