Simplify formula

[Paul_Nepomuceno]

[FONT=&quot]Hi Guys,[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Is there anyway I can simplify this formula?[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]B26 =SUM(AMADEO!F4,CARMONA!F4,'CAVITE CITY'!F4,'DASMA A'!F4,'DASMA B'!F4,'GEN TRIAS'!F4,GMA!F4,IMUS!F4,MANGAHAN!F4,NAIC!F4,ROSARIO!F4,'SILANG I'!F4,'SILANG II'!F4,TANZA!F4,TERNATE!F4)[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]on B27 it should be like this =SUM(AMADEO!F8,CARMONA!F8,'CAVITE CITY'!F8,'DASMA A'!F8,'DASMA B'!F8,'GEN TRIAS'!F8,GMA!F8,IMUS!F8,MANGAHAN!F8,NAIC!F8,ROSARIO!F8,'SILANG I'!F8,'SILANG II'!F8,TANZA!F8,TERNATE!F8)[/FONT]
[FONT=&quot]And so on. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Is there a way to make this easier[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Thank you guys.[/FONT]

 

[FormR]

When I copied the formula on C26 it is giving the same value on B26

Maybe the sum of those cells across all the sheets is the same?

Here is the formula implemented, I only have values in two of the sheets, as shown below:

Excel 2013/2016
	B	C	D
26	2	4	6
27	10	12	14
Sheet1

Cell Formulas
Range	Formula
B26	=SUMPRODUCT(SUM(INDIRECT("'"&{"AMADEO","CARMONA","CAVITE CITY","DASMA A","DASMA B","GEN TRIAS","GMA","IMUS","MANGAHAN","NAIC","ROSARIO","SILANG I","SILANG II","TERNATE"}&"'!F"&(ROWS(B$26:B26)*4)+COLUMNS($B26:B26)-1)))

Excel 2013/2016
	F
4	1
5	2
6	3
7	4
8	5
9	6
10	7
AMADEO

Excel 2013/2016
	F
4	1
5	2
6	3
7	4
8	5
9	6
10	7
CARMONA