Forum Discussion

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
Aug 14, 2021
eoliams

Use SUMIFS:

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

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
Copper Contributor
Aug 14, 2021
I have worked it out finally

=SUMIFS($M$2:$M$573,$F$2:$F$573,"<="&TODAY()-1,$F$2:$F$573,">="&TODAY()-30)
- HansVogelaar
  MVP
  Aug 14, 2021
  eoliams
  
  Ah - you wanted to look at dates before today instead of after today...
eoliams
Copper Contributor
Aug 14, 2021
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
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