Hi Guys,
You've been great support in the past when trying to get a spread sheet to work, but the following code doesn't seem to be working correctly on the spreadsheet below, could anyone please advise on what i need to change?
This i need to calculate the spend from april last year to march this year
=SUMIFS(C:C,$B:$B,">="&DATE(YEAR(TODAY())-2,4,1),$B:$B,"<"&DATE(YEAR(TODAY())-1,4,1))
Thanks
You've been great support in the past when trying to get a spread sheet to work, but the following code doesn't seem to be working correctly on the spreadsheet below, could anyone please advise on what i need to change?
This i need to calculate the spend from april last year to march this year
=SUMIFS(C:C,$B:$B,">="&DATE(YEAR(TODAY())-2,4,1),$B:$B,"<"&DATE(YEAR(TODAY())-1,4,1))
Thanks
NETT SPEND | |
Supplier 1 | |
CREDIT | 100 |
MONTH | |
Apr-17 | £20.00 |
May-17 | £25.00 |
Jun-17 | £30.00 |
Jul-17 | £35.00 |
Aug-17 | £40.00 |
Sep-17 | £45.00 |
Oct-17 | £50.00 |
Nov-17 | £55.00 |
Dec-17 | £60.00 |
Jan-18 | £65.00 |
Feb-18 | £70.00 |
Mar-18 | £75.00 |
Apr-18 | £80.00 |
May-18 | £85.00 |
Jun-18 | £90.00 |
Jul-18 | £95.00 |
Aug-18 | £100.00 |
Sep-18 | £105.00 |
Oct-18 | £110.00 |
Nov-18 | £115.00 |
Dec-18 | £120.00 |
Jan-19 | £125.00 |
Feb-19 | £130.00 |
Mar-19 | £135.00 |
Apr-19 | £140.00 |
May-19 | £145.00 |
Jun-19 | £150.00 |
Jul-19 | £155.00 |
Aug-19 | £160.00 |
Sep-19 | £165.00 |
Oct-19 | £170.00 |
Nov-19 | £175.00 |
Dec-19 | £180.00 |
Jan-20 | £185.00 |
Feb-20 | £190.00 |
Mar-20 | |
Apr-20 | |
May-20 | |
Jun-20 | |
Jul-20 | |
Aug-20 | |
Sep-20 | |
Oct-20 | |
Nov-20 | |
Dec-20 | |
April to March (YTD) | £1,290.00 |
April to March (Previous Year) | £1,830.00 |