Related:
- How to copy a formula across multiple sheets in excel
- How to put same formula in multiple sheets - Best answers
- Copy formula across multiple sheets - Best answers
- How to apply a formula to multiple sheets in excel - How-To - Excel
- Copy formulas from one sheet to another all at once ✓ - Forum - Excel
- Rename multiple sheets in excel vba ✓ - Forum - Excel
- Excel transpose formulas from one sheet to another - How-To - Excel
- How to auto populate data from multiple sheets to a master ✓ - Forum - Excel
10 replies
Mazzaropi
- Posts
- 1861
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 9, 2021
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
Report
subodh
This is helpful.
mmikey45
- Posts
- 6
- Registration date
- Saturday November 8, 2014
- Status
- Member
- Last seen
- November 8, 2014
Worked perfect thanks.
Let me ask the second part to my problem.
I need to create a formula on the summary work sheet that references the result on each one of the daily worksheets. I need it to reference each of the 31 worksheets individually.
Let me ask the second part to my problem.
I need to create a formula on the summary work sheet that references the result on each one of the daily worksheets. I need it to reference each of the 31 worksheets individually.
Mazzaropi
- Posts
- 1861
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 9, 2021
mmikey45,
As I don't know how is your file, I did a small example about my formula:
http://speedy.sh/b8gaE/08-11-2014-en-Kioskea-Indexed-Summary-OK.xlsx
Please, tell us if it worked for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
As I don't know how is your file, I did a small example about my formula:
http://speedy.sh/b8gaE/08-11-2014-en-Kioskea-Indexed-Summary-OK.xlsx
Please, tell us if it worked for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
- Posts
- 1861
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 9, 2021
"...Not sure but I must be missing something...."
That's it.
Try to use it:
Before: =INDIRECT("1" & ROW(A1) & "!$A$1")
Now...: =INDIRECT(ROW(A1) & "!$A$1")
I believe this will work.
--
Belo Horizonte, Brasil.
Marcílio Lobão
That's it.
Try to use it:
Before: =INDIRECT("1" & ROW(A1) & "!$A$1")
Now...: =INDIRECT(ROW(A1) & "!$A$1")
I believe this will work.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
- Posts
- 1861
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 9, 2021
mmikey45, Good morning.
Try to do:
a)Click onthe first TAB name with a rigth bottom.
b) Select all sheets
Type any formula on this first sheet.
NOW, look at the others sheet at same cells if they have or not the same formula you typed on first tab.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to do:
a)Click onthe first TAB name with a rigth bottom.
b) Select all sheets
Type any formula on this first sheet.
NOW, look at the others sheet at same cells if they have or not the same formula you typed on first tab.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
mmikey45
- Posts
- 6
- Registration date
- Saturday November 8, 2014
- Status
- Member
- Last seen
- November 8, 2014
No, I want to start on Summary tab Cell AA10 and enter info from Cell B90 on Worksheet 1, on Cell AA11 on Summary enter info from Cell B90 on worksheet 2. Ending at cell AA41 with info from B90 on worksheet 31
Mazzaropi
- Posts
- 1861
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 9, 2021
Try to do:
SUMMARY TAB
AA10 --> =INDIRECT("Plan" & ROW(A1) & "!$B$90")
Copy it down.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
SUMMARY TAB
AA10 --> =INDIRECT("Plan" & ROW(A1) & "!$B$90")
Copy it down.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
mmikey45
- Posts
- 6
- Registration date
- Saturday November 8, 2014
- Status
- Member
- Last seen
- November 8, 2014
I have done as you suggest. The cells are returning a result of #REF!
Not returning the correct result which should be a number. Cells are formatted for a number with no decimal places.
Thanks for your help,
really appreciate.
Mmikey
Not returning the correct result which should be a number. Cells are formatted for a number with no decimal places.
Thanks for your help,
really appreciate.
Mmikey
mmikey45
- Posts
- 6
- Registration date
- Saturday November 8, 2014
- Status
- Member
- Last seen
- November 8, 2014
I see how it works. I think the issue for mine is the worksheets are named 1, 2, 3, 4, 5, ....., when I changed your worksheet from Plan1 to just 1 it stopped working. When I changed your formula from =INDIRECT("Plan" & ROW(A1) & "!$A$1") to =INDIRECT("1" & ROW(A1) & "!$A$1") it did not work.
Not sure but I must be missing something.
Not sure but I must be missing something.
Subscribe To Our Newsletter!
