Hello everyone, Novice formula help needed.
I have a column named % Probability 7day 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 7days. 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 7day close]:[% Probability 7day 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 crosssheet 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 7day close]:[% Probability 7day 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 crosssheet 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!