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
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
Damien,
How do I attach a file. I put the file in the Browse but it isn't attaching the file. The file you said you sent didn't come thru either.
Steve
Hi Steve
Your formula above doesn't appear to be right.
Assuming your sheet tab names are Sheet1, Sheet2, Sheet3, etc, you should be able to paste the formula exactly as I have provided and get the result straight away (make sure that this formula goes on Sheet1 (where you want the resuly to be).
If your Sheets have proper names, you'll need to change Sheet1, etc, to the correct names.You can also refer to the workbook I had uploaded in the previous post, which has the working formula and examples of G6 input on the sheets.
If you are still having issues, if possible, upload the spreadsheet and I'll help you make the change and send it back.
Good luck!
Cheers
Damien