Topic
How to dynamically SUM data in Microsoft Excel
Instructions
Add these formulas to the cells that will SUM the Row or Column after Salesforce Data replication.
Configure the cell names and Column/Row reference to suite the use-case.
Column SUM: =SUM(D3:INDIRECT("d"&ROW()-1))
Row SUM: =SUM(INDIRECT("A"&ROW()):INDIRECT("C"&ROW()))
Example:
Configure the cell names and Column/Row reference to suite the use-case.
Column SUM: =SUM(D3:INDIRECT("d"&ROW()-1))
Row SUM: =SUM(INDIRECT("A"&ROW()):INDIRECT("C"&ROW()))
Example: