Sumif if question

Hey folks,

Working on a sheet to sum up if checkboxes are selected and running into an issue.

The formula I have now is- =SUMIF(PRD50, 1) + IF(Stories50, 1) + IF(Assets50, 1) + IF(Wires50, 1) + IF(Comps50, 1)

Each one of those are checkboxes and I want to tally them all up. Ideally, I'd like it to equal 100 since that would mean its 100% complete. But my current problem with that formula is that its not counting PRD50. Every combo of IF and brackets I have tried is not working. Any assistance appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!