SUMIFS based on date criteria
I am trying to add the sums of 3 different columns, with the criteria that the date of the rows being summed is created is greater than a certain day.
The formula below has worked for summing just one column based on "Created Date" being greater than 11/10/2021, but when trying to add three columns I'm getting an #INVALID OPERATION error. What am I missing??
=SUMIFS([Column1]:[Column1], [Column2]:[Column2], [Column3]:[Column3], [Created Date]:[Created Date], >DATE(2021, 11, 10))
Help Article Resources
Check out the Formula Handbook template!