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 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?
5 Replies
- I have worked it out finally
=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...
- Okay - I am missing something - So i get my first error when I try and put the " before the &today().
If I take the " away - it accepts the formula but give a result of 0
btw what is the functionality of the & before today
thanks - Hi Hans, i will try that and let you know how it goes - but that formula look like it will do the trick - thanks mate
