Forum Discussion

eoliams's avatar
eoliams
Copper Contributor
Aug 13, 2021
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...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Aug 14, 2021

    eoliams 

    Use SUMIFS:

     

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

HansVogelaar's avatar
HansVogelaar
MVP
Aug 14, 2021

eoliams 

Use SUMIFS:

 

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

eoliams's avatar
eoliams
Copper Contributor
Aug 14, 2021
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