Formula for SUM of cells that have data based on an IF formula


Hi there,

I have some cells that display a dollar amount depending on what drop down option is chosen in another column. I want to do a sum of these dollar amounts but the usual SUM formula is showing zero. Do you have any tips here?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!