Ref SUMIF example in Help


Referring the SUMIF example in the Help article, it is not clear to me why =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3) has the result 3,115.00, and not 2,303.00, that is 1,491.00 + 812.00

Thank you,



Best Answer


  • Hi Genevieve,

    I am glad it turned out to be an error and it will be updated. I just couldn't figure out how it was calculated, that's all, for the moment I don't need help with any specific formula. The example you provided is exactly the one I was referring to, many thanks.



  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Elena,

    Just a quick note to let you know that we've updated our Help Article to reflect the correct number.

    Thanks again for pointing this out to us!


  • Hi Genevieve,

    I am glad it was solved.

    Thank you for your update!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!