Copying formulas to multiple worksheets
Solved/Closed
mmikey45
Posts
6
Registration date
Saturday November 8, 2014
Status
Member
Last seen
November 8, 2014
-
Updated on Jan 29, 2019 at 08:40 AM
subodh - Feb 2, 2019 at 11:40 PM
subodh - Feb 2, 2019 at 11:40 PM
Related:
- How to copy a formula across multiple sheets in excel
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- How to change date format in excel - Guide
- How to copy data from one sheet to another in excel automatically - Guide
- Number to words in excel formula - Guide
- How to screenshot excel sheet - Guide
10 replies
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Nov 8, 2014 at 10:35 AM
Nov 8, 2014 at 10:35 AM
mmikey45, Good morning.
Suppose your sheets have the name: Plan1 Plan2 Plan3...Plan31
You want sum an A10 cell about all sheets.
Try to do:
At SUMMARY, any cell: =SUM(Plan1:Plan31!A10)
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose your sheets have the name: Plan1 Plan2 Plan3...Plan31
You want sum an A10 cell about all sheets.
Try to do:
At SUMMARY, any cell: =SUM(Plan1:Plan31!A10)
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Feb 2, 2019 at 11:40 PM