Forum Discussion
Repetitive Formulas
Is there a way to copy formulas accumulating totals without retyping each formula. For example we need to total vendor by vendor month by month spending and accumulate those totals in a spreadsheet ...
Hi, to all!
Check this formula applied in workbook:
C4 : =SUMPRODUCT(SUMIF(INDIRECT("'"&$E$4:$E$15&" "&RIGHT($D$1,2)&"'!B4:B42"),$B4,INDIRECT("'"&$E$4:$E$15&" "&RIGHT($D$1,2)&"'!D4:D42")))
D4 : =SUMPRODUCT(SUMIF(INDIRECT("'"&$E$4:$E$15&" "&RIGHT($D$1,2)&"'!B4:B42"),$B4,INDIRECT("'"&$E$4:$E$15&" "&RIGHT($D$1,2)&"'!E4:E42")))
Check file. Blessings!
Thanks John! That is certainly less repetitive than my own attempt!