I am trying to create a sumifs formula with 3 criteria and am having difficulty creating a valid 3rd criteria.
=SUMIFS('TabA'!G:G,'TabA'!A:A,A4,'TabA'!B:B,B4,'TabA'!J:J,+'TabA'!J4">=&TODAY()")
What I would like the 3rd criteria to do is return the values in column G of TabA where the values in column J of TabA are greater than or equal to today's date.
I have not used a date previously in a sumifs and am having trouble getting the formatting of the criteria correct.
Bookmarks