Mattdim805
New Member
- Joined
- Dec 11, 2013
- Messages
- 11
You can reference my Google Sheet here.
I'm looking to create a formula in Google Sheets that will aggregate (sum) the values for daily records into a weekly output, allowing me to see the absolute and percentage gains/losses on a weekly basis.
i.e. Column L should calculate the Weekly Gain/Loss in absolute value, and column M in percentage value.
What formula can I use to allow me to sum the gains/losses on a weekly basis, and then compare them to the prior weeks' results?
I'm looking to create a formula in Google Sheets that will aggregate (sum) the values for daily records into a weekly output, allowing me to see the absolute and percentage gains/losses on a weekly basis.
i.e. Column L should calculate the Weekly Gain/Loss in absolute value, and column M in percentage value.
What formula can I use to allow me to sum the gains/losses on a weekly basis, and then compare them to the prior weeks' results?