SUMIF reads the labels for you — one formula rolls up an entire segment.
The freight desk sends its revenue as a raw ledger — one line per booking, the segment written out beside each amount — and the deck needs it by segment. A summary block is already framed on the right, its segments listed in its own order with a Total row waiting under them. Roll the ledger up into it, foot the summary, and show each segment as a share of the total.
Alt walks: tap Alt, release, then the letters in sequence — each key steps one ribbon menu. On a Mac, tap ⌥ and use the same letters (KeyTips, Excel 2024+).
Ctrl+D⌘D on macFill down from the cell above
Build the logic once in the top cell, select down, and stamp it — the standard way to fill a schedule.
Ctrl+B⌘B on macBold
Bold marks structure: titles, total rows, anything the reviewer’s eye should land on first.
Alt h b p⌥ h b p on macTop border
Top border above a total row — the accounting ruling that says “this line sums the ones above.”
Ctrl+1⌘1 on macOpen the Format Cells dialog
The master formatting dialog — number formats, alignment, borders in one place when a ribbon walk would take longer.
functions you'll type: SUMIF() · SUM()
the par-setting sequence, straight through:
E4 =SUMIF($A$4:$A$14,D4,$B$4:$B$14) · select E4:E6 ctrl+d · E7 =SUM(E4:E6) · D7:E7 ctrl+b + alt h b p · F4 =E4/$E$7 · fill F4:F6 ↓ · ctrl+1 p · ctrl+s