Ref SUMIF example in Help

Elena Codrea

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

Genevieve P.

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

Genevieve P.

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

Elena Codrea

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.

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

Elena Codrea

Hi Genevieve,

I am glad it was solved.

Thank you for your update!

Elena