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

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