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 |
