I have probably 60 rows that have percentage calculations to come up with a
dollar figure. When I then take all those numbers and add them to see total
dollars, I have found that the bottom line is not correct. I routine run
another column, manually adding the dollars for each cell as a double check.

How can I make sure my totals are correct without having to manually add
them. How to I make the sum take the end dollar amount and not be looking at
the calculation anymore?