Hi Guys,
The sheet shown below tracks spend by calendar years and we need to change it to spend by tax/fiscal years April to March. Does anyone know how to do this ?
Thanks
<tbody>
</tbody>
The formula used for the current year is "=SUMPRODUCT((YEAR($A$3:$A$26)=YEAR(TODAY()))*B$3:B$26)"
The formula used for the previous year is "=SUMPRODUCT((YEAR($A$3:$A$26)=YEAR(TODAY())-1)*B$3:B$26)"
The formula used for 2 previous years is "=SUMPRODUCT((YEAR($A$3:$A$26)=YEAR(TODAY())-2)*B$3:B$26)"
Thanks
The sheet shown below tracks spend by calendar years and we need to change it to spend by tax/fiscal years April to March. Does anyone know how to do this ?
Thanks
| Supplier 1 |
MONTH | |
Apr-17 | £59.00 |
May-17 | £60.00 |
Jun-17 | £61.00 |
Jul-17 | £62.00 |
Aug-17 | £63.00 |
Sep-17 | £64.00 |
Oct-17 | £65.00 |
Nov-17 | £66.00 |
Dec-17 | £67.00 |
Jan-18 | £68.00 |
Feb-18 | £69.00 |
Mar-18 | £70.00 |
Apr-18 | £71.00 |
May-18 | £72.00 |
Jun-18 | £73.00 |
Jul-18 | £74.00 |
Aug-18 | £75.00 |
Sep-18 | £76.00 |
Oct-18 | £77.00 |
Nov-18 | £78.00 |
Dec-18 | £79.00 |
Jan-19 | £80.00 |
Feb-19 | £81.00 |
Mar-19 | £81.00 |
Jan to Dec 2019 | £ 242.00 |
Jan to Dec 2018 | £ 882.00 |
Jan to Dec 2017 | £ 567.00 |
<tbody>
</tbody>
The formula used for the current year is "=SUMPRODUCT((YEAR($A$3:$A$26)=YEAR(TODAY()))*B$3:B$26)"
The formula used for the previous year is "=SUMPRODUCT((YEAR($A$3:$A$26)=YEAR(TODAY())-1)*B$3:B$26)"
The formula used for 2 previous years is "=SUMPRODUCT((YEAR($A$3:$A$26)=YEAR(TODAY())-2)*B$3:B$26)"
Thanks