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
Best Answer
-
Hi Elena,
You are absolutely correct, the total should be 2,303.00. Thank you for pointing this out! I have submitted feedback to our Help Center team so they know this article needs to be updated.
Here's an example of how it will work in your sheets:
Let me know if you have a specific SUMIF formula that you need help with!
Cheers,
Genevieve
Answers
-
Hi Elena,
You are absolutely correct, the total should be 2,303.00. Thank you for pointing this out! I have submitted feedback to our Help Center team so they know this article needs to be updated.
Here's an example of how it will work in your sheets:
Let me know if you have a specific SUMIF formula that you need help with!
Cheers,
Genevieve
-
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
-
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
Categories
Check out the Formula Handbook template!