How do you sum totals of a column that include "No Match" cells?

Hello,

I have been trying to search online but can't seem to find the answer to my question.

What is the formula to sum cells in a column that include some "No Match" cells?

Much appreciated,

Cheers

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!