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!

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.