Forum Discussion
Solved
Need help with a SumIF
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 trai...
I have worked it out finally
=SUMIFS($M$2:$M$573,$F$2:$F$573,"<="&TODAY()-1,$F$2:$F$573,">="&TODAY()-30)
=SUMIFS($M$2:$M$573,$F$2:$F$573,"<="&TODAY()-1,$F$2:$F$573,">="&TODAY()-30)
Ah - you wanted to look at dates before today instead of after today...