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?



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!