Where am I going wrong in this SUMIF formula?

Here is my formula: =SUMIF({Shell Projects - High Level Tracker CP}, Wholesaler@row, {Shell Projects - High Level Tracker Owner})

I'm trying to say, if the "Owner" on another sheet equals the Wholesaler on the row on my sheet, then sum the CP on that other sheet.

The formula isn't throwing any errors, but is return an answer of "0" which is not correct.

Kelly L. Gabel


Tech-Savvy Academy



Best Answer

  • KT_H
    KT_H ✭✭✭
    Answer ✓

    Hi Kelly,

    You have the sum range and the criterion range flipped, try this.

    =SUMIF({Shell Projects - High Level Tracker Owner}, Wholesaler@row, {Shell Projects - High Level Tracker CP} )


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!