My SUMIF formula is returning "0", what am I doing wrong?

I have a SUMF formula which is returning "$0" for the value I am trying to sum. My range and criterion is a number (employee id) is this possibly what is throwing it off? Will the formula read a number for for range and criterion?

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 04/22/22 Answer ✓

    Hey @MeyerL

    May I offer it appears the employee ID is text in one sheet and a number value in the other. I say this noticing how [Employee ID] is left justified in one sheet and right justified in the other. It surprised me it made a difference but I verified the effect in my sheet. Building on the formula y'all have already worked out:

    =SUMIF({CA}, CONTAINS([Employee ID]@row,@cell), {NSR})



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!