View Single Post
 
Old 11-30-2023, 10:12 AM
Karen615 Karen615 is offline Windows 11 Office 2021
Competent Performer
 
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default SUM Two Cells Above & Format to Currency

Using MS 365

I have a table with three blank cells in one column. I want to be able to type in a currency amount in both blank cells (or have it formatted to currency) and then have Word SUM the currency amount in the other blank cell. From my research, there has to be a value in the cells and then you can add the formula =SUM(ABOVE) or just click the AutoSum button.

Is there a way to:
Format all cells to currency.
Type in a formula to SUM the cells once values are added.

Thank you in advance for your help.
Karen
Reply With Quote