User Profile
Paul_bentham
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Formula to calc YTD % variance on a month by month basis
Riny_van_Eekelen Hi Riny, In column "N" I'd like to show the accumulative, Year to date Variance in consumption shown in Column "L" against the same periods in 2019, Column "C". Example at Cell "N7" shows the variance for the single month of April 2021 v April 2019. In Cell "N8" I'd like to show the variance of the consumption used in April and May 2021 (Cells L7 + L8) against the same two months in 2019 (Cells C7+C8) and show the variance in cell "N8". In Cell "N9" should continue the above but include the total usage/consumption of April, May and June 2021 v the same 3 months in 2019. Cells N10, N14, N18 and N22 already show the quarterly variance year on year so you can ignore those cells . Hope this makes sense and you can assist. many thanks.4.5KViews0likes1Comment
Recent Blog Articles
No content to show