If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding over 30 worksheets in a workbook
Happy Holidays! How can I SUM the value of the same cell located in over 30
worksheets in the same workbook to get a grand total of all those values? I currently get a message back stating my formula is too long. Appreciate the help! -- -E |
#2
|
|||
|
|||
Adding over 30 worksheets in a workbook
Hi,
Try, =SUM(Sheet1:Sheet30!A44) Change A44 for the cell where the totals are If this helped you please say yes, thank you and Happy Holidays "-E" wrote: Happy Holidays! How can I SUM the value of the same cell located in over 30 worksheets in the same workbook to get a grand total of all those values? I currently get a message back stating my formula is too long. Appreciate the help! -- -E |
#3
|
|||
|
|||
Adding over 30 worksheets in a workbook
Perhaps I needed to state that each worksheet has a unique name (a person).
I did try going to the first worksheet, held down the shift key, then went to the last worksheet, then entered the appropriate cell, but it didn't work. Any further suggestions? Thanks! -- -E "Eduardo" wrote: Hi, Try, =SUM(Sheet1:Sheet30!A44) Change A44 for the cell where the totals are If this helped you please say yes, thank you and Happy Holidays "-E" wrote: Happy Holidays! How can I SUM the value of the same cell located in over 30 worksheets in the same workbook to get a grand total of all those values? I currently get a message back stating my formula is too long. Appreciate the help! -- -E |
#4
|
|||
|
|||
Adding over 30 worksheets in a workbook
Never mind my previous response. I went back and retried it and it did work!
Thanks so much!!! Happy New Year! -- -E "Eduardo" wrote: Hi, Try, =SUM(Sheet1:Sheet30!A44) Change A44 for the cell where the totals are If this helped you please say yes, thank you and Happy Holidays "-E" wrote: Happy Holidays! How can I SUM the value of the same cell located in over 30 worksheets in the same workbook to get a grand total of all those values? I currently get a message back stating my formula is too long. Appreciate the help! -- -E |
#5
|
|||
|
|||
Adding over 30 worksheets in a workbook
Happy new year to you too,
If my answer helped please say yes, thanks "-E" wrote: Never mind my previous response. I went back and retried it and it did work! Thanks so much!!! Happy New Year! -- -E "Eduardo" wrote: Hi, Try, =SUM(Sheet1:Sheet30!A44) Change A44 for the cell where the totals are If this helped you please say yes, thank you and Happy Holidays "-E" wrote: Happy Holidays! How can I SUM the value of the same cell located in over 30 worksheets in the same workbook to get a grand total of all those values? I currently get a message back stating my formula is too long. Appreciate the help! -- -E |
Thread Tools | |
Display Modes | |
|
|