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
-
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
-
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.
-
Perfect Mark, that worked.
Best
-
Excellent. Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!