I am wanting to create a formula that will look at a dozen different cells and sum to the total value of those cells but some cells will not be numbers and I want to exclude those cells in the sum.

For example:

D2=`10`

H2=`IF(B1="BYO","Incl.",5)`

M2=`IF(A1="standard","Incl.",15)`

then I want to have Z2=`SUM(D2+H2+M2)`

but sometimes the values will be numbers other times they will be text.

I was playing around using IFS and trying to use syntax like <> “Incl.” but I couldn’t figure out how to make it work with different cells that may or may not be numeric.