=SUM cells that contain formula(s) are adding up to 0$ total

James123

Hi , can someone help me with this one ?

I am attempting to SUM the totals of these cells, they contain formulas in them and are resulting into a 0$ total.

https://jmp.sh/NKbWlTa

Sameer Karkhanis

That is because outcome of the formulas in the cells Drug 1,2,3 are text and not numbers. Please update the formula to output numbers (i.e., 242.24 instead of "$242.24" and also for others). You can format all four columns to display as Currency USD instead.

James123

Hi when I remove the "" it shows #UNPARSEABLE message