Sum with CountIfs


I'm trying to sum if column 1 below = Yes and column 3 below = Yes.....I would like to return the value 2 since both say Yes. My formula isn't delivering this result.

=sum(countifs([Frame JC306395 Has Green QC Inspection Sticker]@row,"Yes",[2 Capacitor Racks Have Green QC Inspection Sticker]@row,"Yes))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!