Cross Sheet Formula Help - SUMIF, SUMIFS, OR - Which to use?

I'm trying to create a cross sheet formula that will track the dollars spent on items in various stages. I've easily created formulas for two separate stages, "Pending" and "Requisitioned".

I'm struggling now to create a cross sheet formula that encompasses everything past "Purchased". This includes "Received", "In Storage", and "Installed" along with "Purchased".

Which function can help me with this? I've tried searching but everything I've found is for multiple conditions across various columns. I have all these stages in the same column.

Thank you all so much! I'm excited to start posting more in this community!

Best,

Jim

Find more posts tagged with

Formulas

Accepted answers

All comments

Nic Larsen

Based on the limited info, it sounds like you need to use something like this and just continue to add your conditions.

OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell)

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.