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

James123 · 09/02/22

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.

Sameer Karkhanis · 09/02/22

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 · 09/07/22

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

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

Answers

Help Article Resources

Categories