Hello everyone,
In the variance column I would like a dynamic formula that finds the difference between the current month for example Nov 21 and the difference between the previous month Oct 21. I have been manually inputting =g4-f4 and dragging the formula down for the variance column each month. I have tinkered with an offset formula - =(OFFSET($B$17,0,COUNT(C17:N17),1,-2)) but I don't know how to include the subtraction component. Works perfectly if I wanted to SUM the cells, but I need to find the difference.
Thank you.
In the variance column I would like a dynamic formula that finds the difference between the current month for example Nov 21 and the difference between the previous month Oct 21. I have been manually inputting =g4-f4 and dragging the formula down for the variance column each month. I have tinkered with an offset formula - =(OFFSET($B$17,0,COUNT(C17:N17),1,-2)) but I don't know how to include the subtraction component. Works perfectly if I wanted to SUM the cells, but I need to find the difference.
Thank you.
Invoice Description | Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Variance |
0 - 3 months old | 10 | 10 | 12 | 6 | 8 | 2 | |||||||
3 - 6 months old | 7 | 7 | 7 | 9 | 7 | (2) | |||||||
6 - 12 months old | 3 | 5 | 6 | 9 | 11 | 2 | |||||||
Over 12 months old | 22 | 22 | 21 | 22 | 22 | - | |||||||
Total Invoices | 42 | 44 | 46 | 46 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |