SUMIFS - Formula correct but not working in Sheet Summary

I'm trying to add a Sheet Summary that will look sum cell with $ based on 2 other criteria in drop down columns. It won't return any data:

FORMULA:

=SUMIFS(Estimated Rev $:Estimated Rev $, Probability:Probability,"P10", Business:Business, "Spare Sales")

Estimated Rev $: Free Text Field range from 0 and greater

Probability: Drop Down Field with following options:

P10

P30

P50

P70

P90

P100

Business: Drop Down Field with following options:

ASP

Spare Sales

Repowering

Trusted Advisor

Sure my issue is something simple. Would appreciate any insight.

Find more posts tagged with

Accepted answers

Mark Cronk

Good evening,

Try:

=SUMIFS([Estimated Rev $]:[Estimated Rev $], Probability:Probability, @cell="P10", Business:Business, @cell="Spare Sales")

Mark

All comments

Mark Cronk

Good evening,

Try:

=SUMIFS([Estimated Rev $]:[Estimated Rev $], Probability:Probability, @cell="P10", Business:Business, @cell="Spare Sales")

Mark

Josh Fraughton

Perfect Mark, that worked.

Best

Mark Cronk

Excellent. Glad you found a solution. Thank you for contributing to the Community.

Mark

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.