koppahollic
New Member
 Joined
 Oct 26, 2020
 Messages
 4
 Office Version

 2013
 Platform

 Windows
I am simply trying to calculate a percent clicked figure (in regard to email campaign metrics) that will update accordingly when applying filters to the data.
In my spreadsheet for example.... In Column M (M5204), I have the number of clicks and in Column G (G5204) is the number of emails sent. I have a results section in rows 14 that recalculates metrics based on when filters are applied to the data (sorting by email campaign for example). The calculation itself is simple... Column M divided by Column G will give you the percent clicked figure I'm after. But I can't figure out how to make that particular results cell automatically update when I filter the data.
I have been able to use the Subtotal Formula fine for calculating one column of data. But can this be used for calculating a formula with two columns of data like I'm trying to do above, if so do you mind sharing what that formula looks like?
In my spreadsheet for example.... In Column M (M5204), I have the number of clicks and in Column G (G5204) is the number of emails sent. I have a results section in rows 14 that recalculates metrics based on when filters are applied to the data (sorting by email campaign for example). The calculation itself is simple... Column M divided by Column G will give you the percent clicked figure I'm after. But I can't figure out how to make that particular results cell automatically update when I filter the data.
I have been able to use the Subtotal Formula fine for calculating one column of data. But can this be used for calculating a formula with two columns of data like I'm trying to do above, if so do you mind sharing what that formula looks like?