How to SUMIF in Smartsheet with multiple criteria requirements from one column

I am having difficulty transferring the formula below from Excel over to Smartsheet.

Below is the current formula I need from Excel. I need Smartsheet to produce the same result. I'm new to Smartsheet and have gone through the self-help videos, directions, and pop-ups to see if I can get the formula below to work in Smartsheet, but I wasn't able to figure out how to accomplish this. If you know how to make this happen, I will highly appreciate your help. Thank you in advance for your help.

=SUM(SUMIF($H$40:$H$79,{"Estimated","Pending","Approved"},$G$40:$G$79))

Find more posts tagged with

Formulas

Accepted answers

Sameer Karkhanis

Make sure you replace the columns names correctly and also the row numbers as appropriate in your sheet

=SUMIF([Your Status Column Name]40:[Your Status Column Name]79, OR(@cell = "Estimated", @cell = "Pending", @cell = "Approved"), [Your Value Column Name]40:[Your Value Column Name]79)

All comments

Sameer Karkhanis

Make sure you replace the columns names correctly and also the row numbers as appropriate in your sheet

=SUMIF([Your Status Column Name]40:[Your Status Column Name]79, OR(@cell = "Estimated", @cell = "Pending", @cell = "Approved"), [Your Value Column Name]40:[Your Value Column Name]79)

TW12345

Awesome, THANK YOU Sameer. I was able to translate it over. Thank you so much for your help on this. Many Thanks again.

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.