Drawloop - Dynamically SUM Replicated Data Excel

  • 15 February 2022
  • 0 replies
  • 108 views

Userlevel 3
Badge +8

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:
5209i179001B1958FEA4C.png

 


0 replies

Be the first to reply!

Reply