Original types · deliberate summaries

Why did my Pivot choose Count?

Trace numbers, text and true blanks in the actual worksheet. Follow the highlighted cells, then unlock the same workbook to try your own values.

Teaching · read-only · Report!A1

Step 1 / 6Insert an all-numeric field

Inspect

Restore the two demonstration cells to numbers and insert Amount. The original field is numeric, including zero and a refund, so its insertion default is Sum. Any other current text or blanks still affect reinsertion. Teaching is read-only; switch to Your turn to edit.

Types and summaries!K2 · (blank)
No formula applied

Preparing the typed source worksheet…

Correct source/control cells or explicitly repair edited helpers. Previous valid totals remain until correction.

Choose the summary on this worksheet

Active: sum. If inserted now: sum. Source edits retain the active choice; reinsertion chooses again.

Current original-record totals
Team	Sum	Count	Count Numbers	Selected
North	140	3	3	140
South	110	3	3	110
Grand total	250	6	6	250

Non-OLAP, 1–50 records and at most 12 teams. This lab accepts finite numbers, nonempty text and true blanks. Boolean/date/error and formula-empty populations are separate lessons. Native files retain source facts and typed cache entries; desktop Excel refresh/edit/save is not yet certified.

Microsoft: Pivot summary defaults and nonempty Count