# SUMIFS based on date criteria

Options
edited 11/16/21

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))

Thank you!

• ✭✭✭✭✭✭
Options

SUMIFS only sums one range. The other ranges are for different evaluation criteria.

You could try:

=SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column1]:[Column1]) + SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column2]:[Column2]) + SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column3]:[Column3])

A bit brute-force, but it should work.

dm

• ✭✭✭✭✭✭
Options

SUMIFS only sums one range. The other ranges are for different evaluation criteria.

You could try:

=SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column1]:[Column1]) + SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column2]:[Column2]) + SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column3]:[Column3])

A bit brute-force, but it should work.

dm

• edited 11/17/21
Options

@Dale Murphy Thank you so much! This worked perfectly. I didn't know that about SUMIFS - makes sense.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!