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.

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Good evening,

    Try:

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


    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!