Supermetrics Support Forum

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?

  • 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 to post a comment