Is my SUMIFS formatted improperly?

I'm looking to sum $ column when Status column is "Contracted" and when Job Type column is either "Balcony" OR "Roof Anchor"

This is what I have:

=SUMIFS([$]:[$], Status:Status, "Bidding", [Job Type]:[Job Type], OR(@cell = "Roof Anchor", @cell = "Balcony"))

The result is: #INVALID OPERATION

I feel I'm probably missing something simple, but it seems to match the examples I have seen elsewhere.

Thank you.

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

Jason Malgren

Disregard this question, the formatting was fine, I had an invalid value in one of the columns which was throwing an error in the equation.

Genevieve P.

Hi @Jason Malgren

I'm glad you were able to sort this out! Thanks for posting your solution.

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.