Add a totals row
Add a bold total under column B and show it as currency.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write "Total" in A101
- B101 = SUM of B2:B100
- Make the totals row bold
- Show column B as $1,234.00
Use it in MacroRoni: open the Starter gallery, search for "Add a totals row", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More calculations macros
CalculationsRunning totalAdd a running total of column B in column C.Changes data · backup onCalculationsCount and total one categoryCount the rows where column A says Sales and add up their amounts from column B.Changes data · backup onCalculationsPercent of totalShow what share of the column B total each row is, in column D.Changes data · backup on