Formula for SUM of cells that have data based on an IF formula
Options
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?
Thanks!
Answers

Hi @ememma,
Can you post a screenshot of the relevant columns (hide any sensitive data) as well as the formula you're using to generate the dollar amount which needs summing?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!