Hi Guys,
Is there anyway I can simplify this formula?
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)
on B27 it should be like this...