SOLVED

# Need help with a SumIF

Occasional Contributor

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

# Re: Need help with a SumIF

Use SUMIFS:

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

# Re: Need help with a SumIF

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

# Re: Need help with a SumIF

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

# Re: Need help with a SumIF

I have worked it out finally

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

# Re: Need help with a SumIF

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