koppahollic
New Member
- Joined
- Oct 26, 2020
- Messages
- 8
- 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 (M5-204), I have the number of clicks and in Column G (G5-204) is the number of emails sent. I have a results section in rows 1-4 that re-calculates 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 (M5-204), I have the number of clicks and in Column G (G5-204) is the number of emails sent. I have a results section in rows 1-4 that re-calculates 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?