Forumal Help
Hi
Would anyone have a correct formula for =sum of {range}, if {date range}is less than a specific date
So I'm adding values in a column, I have another column of dates, I want the formula to add the values only if they are less than 01 01 2022.
Anyone?
Answers
-
=Sumif({date range},<Date(2022,1,1),{range to sum} should work
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!