Ref SUMIF example in Help

Hi,

Referring the SUMIF example in the Help article https://help.smartsheet.com/function/sumif, 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,

Elena

Tags:

Best Answer

Answers

  • 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.

    Cheers,

    Elena

  • 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!

    Genevieve

  • Hi Genevieve,

    I am glad it was solved.

    Thank you for your update!

    Elena

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!