How to compute the total cost and referring to the rate as an absolute cell reference

How to compute the total cost and referring to the rate as an absolute cell reference

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Hi

Do you mean you wish to sum the contents of specific cells and then refer to the total as an absolute reference?

A basic formula for summing cell contents would be

`=SUM(A1:A10)`

But this assumes you want to sum the contents in cells A1 to A10. Simply replace with your cell range. If you want it as absolute, then the formula should be

`=SUM($A$1:$A$10)`

Thanks