I have a table that is split by my ad sets in Facebook. The number of rows of ad sets will vary as I bring live new ad sets and pause old ones. I would like a "Totals" row to always be at the bottom of my table. Given that the number of rows will be varying, how do I set that up?
you can make a function that sums the whole row, despite of the number of cells with "=SUM(A2:A)" -but unfortunately I couldn't come up with a solution that makes a function automatically move to the end of the row of data. You could try asking Google Sheets forum if anyone knows a solution for this.