cancel
Showing results for 
Search instead for 
Did you mean: 

Drawloop - Dynamically SUM Replicated Data Excel

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:
User-added image

Labels: (2)
Tags (1)
Version history
Revision #:
25 of 29
Last update:
3 weeks ago
Updated by: