SUMIFS - Formula correct but not working in Sheet Summary

Josh Fraughton

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.

Mark Cronk

Good evening,

Try:

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

Mark

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