SUMIF Trouble
I am trying to use SUMIF to add the dollar amount for jobs that have 100% probability. I wrote this formula: =SUMIF(Probability:Probability, "100%", [Quoted Amount]:[Quoted Amount]) and it returns a 0 but no error. Also all of the data in this sheet is linked from another sheet. Is the problem because the data is linked?
Comments
-
The problem might be because Smartsheets recognizes percentage formatted columns as decimals in the back end... try, =SUMIFS([Column to sum]:[Column to sum], Probability:Probability, 1)
25% will be read as .25, 50% as .5, and 100% as 1. Hope that helped! I also updated your sumif to a sumifs so you can add additional criterion if ever needed.
You will also need to indicate the column to sum. If you put this formula in the same column as the sum itself it will give you a circular reference. Make sure your summary formula is in a different column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!