Sum if number is positive

craig 2022
craig 2022 ✭✭
edited 02/16/23 in Formulas and Functions

Hi, i have YTD row that calculates the sum of all the month values (numbers) from Jan-Dec (each month has a column named Jan, Feb, March etc). However I want to only include months inthe sum when the month value is greater than zero (i.e. is not a negative number)

any help would be super-duper appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!