SOLVED

Need help with a SumIF

Copper Contributor

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
best response confirmed by eoliams (Copper Contributor)
Solution

@eoliams 

Use SUMIFS:

 

=SUMIF($M$2:$M$573,$F$2:$F$573,">="&TODAY()+1,$F$2:$F$573,"<="&TODAY()+30)

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
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
I have worked it out finally

=SUMIFS($M$2:$M$573,$F$2:$F$573,"<="&TODAY()-1,$F$2:$F$573,">="&TODAY()-30)

@eoliams 

Ah - you wanted to look at dates before today instead of after today...

1 best response

Accepted Solutions
best response confirmed by eoliams (Copper Contributor)
Solution

@eoliams 

Use SUMIFS:

 

=SUMIF($M$2:$M$573,$F$2:$F$573,">="&TODAY()+1,$F$2:$F$573,"<="&TODAY()+30)

View solution in original post