SUMIF Formula - Incorrect Result?

yheng ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello, I was looking over the SUMIF function yesterday on this page and noticed the incorrect result for the first row example. Am i wrong or should the correct result be $2303.00?


=SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3)Revenue Gained. SUM Transaction Total if Price Per Unit is greater than 20.003,115.00





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!