Start a new topic

Creating Total Field that Will Populate at bottom of Table with varying number of row


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?

1 Comment

Hi Chris,

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.

Best regards,

Jouni Hyötylä

Twitter: @Supermetrics 

Support forum: supermetrics/forum

Login or Signup to post a comment