Count and total one category
Count the rows where column A says Sales and add up their amounts from column B.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write "Sales rows" in E1
- F1 = how many rows say Sales
- Write "Sales total" in E2
- F2 = total of column B for Sales
Use it in MacroRoni: open the Starter gallery, search for "Count and total one category", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More calculations macros
CalculationsAdd a totals rowAdd a bold total under column B and show it as currency.Changes data · backup onCalculationsRunning totalAdd a running total of column B in column C.Changes data · backup onCalculationsPercent of totalShow what share of the column B total each row is, in column D.Changes data · backup on