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

ememma

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!

Nick Korna

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?