Hello!
This is my first time posting on these forums so bear with me please.
I had a question about possibly getting the sum of one specific cell from every worksheet INCLUDING the ones that do not exist yet.
***NOTES***
1. Every worksheet in the spreadsheet have the same template.
2. I want the sum of all I26 cells in every worksheet
3. I used the formula =SUM('*'!I26), which works fine; HOWEVER, it does not update when I add in another worksheet to the spreadsheet.
4. The worksheet names do not have a specific pattern (i.e. one worksheet is named "AAA" while another is named "El Mercado.")
I read somewhere that I can use the INDIRECT function using arrays, but the problem is that I haven't found one solution where the worksheets names are all different.
Is this possible?
Thank you,
Jay
This is my first time posting on these forums so bear with me please.
I had a question about possibly getting the sum of one specific cell from every worksheet INCLUDING the ones that do not exist yet.
***NOTES***
1. Every worksheet in the spreadsheet have the same template.
2. I want the sum of all I26 cells in every worksheet
3. I used the formula =SUM('*'!I26), which works fine; HOWEVER, it does not update when I add in another worksheet to the spreadsheet.
4. The worksheet names do not have a specific pattern (i.e. one worksheet is named "AAA" while another is named "El Mercado.")
I read somewhere that I can use the INDIRECT function using arrays, but the problem is that I haven't found one solution where the worksheets names are all different.
Is this possible?
Thank you,
Jay