SumIf if cell is a number

Hello! I am trying to create a formula that calculates the sum of the following columns: Column1,Column2, and Column3. These single select dropdown columns are restricted to the options N\A & numbers 0-10. I need to create a formula that omits the option N\A and sums the other columns. Thanks!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!