Hello everyone, Novice formula help needed.
I have a column named % Probability 7-day close that shows the percentage probability of closing the amount listed in the Forecast Amount column. I'm in need of a formula that can capture every time 25% is listed and sum the totals from the Forecast Amount column, so I have an overall total of every cell tagged as having a 25% chance of closing in 7-days. I'd like to do this for each percentage. 25%, 50%, 75% & 100%. Thank you in advance for taking the time out of your day to provide help. Much appreciated.
Best Answer
-
Hi @C. Phillips ,
Where are you planning on tracking this information? Will it be a summary field on this sheet or tracked in a separate sheet?
If stored on this sheet, the formula for 25% would like the following.
=SUMIF([% Probability 7-day close]:[% Probability 7-day close], =0.25, [Forecast Amount]:[Forecast Amount])
For the other values, change the .25 to .5, .75, and 1.
If you are going to track this information on a separate sheet, the ranges need to change to be cross-sheet references.
Hope this helps,
Dave
Answers
-
Hi @C. Phillips ,
Where are you planning on tracking this information? Will it be a summary field on this sheet or tracked in a separate sheet?
If stored on this sheet, the formula for 25% would like the following.
=SUMIF([% Probability 7-day close]:[% Probability 7-day close], =0.25, [Forecast Amount]:[Forecast Amount])
For the other values, change the .25 to .5, .75, and 1.
If you are going to track this information on a separate sheet, the ranges need to change to be cross-sheet references.
Hope this helps,
Dave
-
This worked perfectly for my needs. Thank you very kindly for taking time out of your day to provide help and support. I truly appreciate it. Hope you have a great day!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 217 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!