Aug 13 2021 11:40 PM
Hi Guys. I have a spreadsheet with invoices and payment over the last two years
I have been using the Sumif and Sumifs functions to isolate the differt products.
I now need to so a a age trail 30,60,90 and 120+
With the SUMIF functions I understand the ranges, but how do i add the criteria of a date between day 1 and day 30 from today?
=SUMIF($F$2:$F$573,????????,$M$2:$M$573)
Any one know - or is there any other function that I can combine with SUMIF to get the figure?
Aug 14 2021 12:30 AM
SolutionAug 14 2021 12:33 AM
Aug 14 2021 12:50 AM
Aug 14 2021 02:08 AM
Aug 14 2021 03:19 AM
Ah - you wanted to look at dates before today instead of after today...
Aug 14 2021 12:30 AM
SolutionUse SUMIFS:
=SUMIF($M$2:$M$573,$F$2:$F$573,">="&TODAY()+1,$F$2:$F$573,"<="&TODAY()+30)