Sum if number is positive

craig 2022

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.

thanks!

Jeff Reisman

@craig 2022 You can try using a SUMIF formula:

=SUMIF(Jan@row:Dec@row, @cell > 0)

This will only add the values that are greater than 0.

Jeff Reisman

@craig 2022 You can try using a SUMIF formula:

=SUMIF(Jan@row:Dec@row, @cell > 0)

This will only add the values that are greater than 0.

Victoria_Indimar

Hello! Have you tried the SUMIF function? =SUMIF({Range},>0,{Range})

craig 2022

Jeff thanks soooo much! that did it.

Jeff Reisman

https://community.smartsheet.com/discussion/comment/362867#Comment_362867

Excellent!