SUMIFS

Hi,

I'm looking to sum the cells in a column if another corresponding column is either of two values. I'm getting #UNPARSEABLE though! 😕

=SUMIFS({Data Range Spend}, {Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”))

Any thoughts welcome!

Thanks,

Derek

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Looks like you have smart quotes from a program similar to Microsoft Word.

Try retyping directly in Smartsheet, and you will see that the quotes are straight up and down instead of slanted. This should take care of it for you.

All comments

Paul Newcome

Looks like you have smart quotes from a program similar to Microsoft Word.

Try retyping directly in Smartsheet, and you will see that the quotes are straight up and down instead of slanted. This should take care of it for you.

Del Horne

@Paul Newcome you are a saviour!

I pasted the formula into TextEdit to size up to look at the issue...not thinking to convert to plain text. Arrrrrgh. Thank you!!

Paul Newcome

Happy to help. 👍️

I usually use Notepad for that as it also uses plain text.

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.