How it works
Parse nonblank selected cells as numbers; calculate count, sum, mean, minimum and maximum using decimal arithmetic.
Input definitions
- CSV with header
- Plain text; maximum 200,000 characters.
- Numeric column name
- Enter the value in the labeled unit.
A worked example
- CSV with header
- name,city,score Ada,London,10 Lin,Paris,20 Sam,London,30
- Numeric column name
- score
Assumptions & limits
Plain text on your device, with no remote fetch. CSV input is comma-separated with unique nonempty headers, at most 1,000 rows and 50 columns; downloads escape spreadsheet formula prefixes.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Are blank cells included in the mean?
No. Blank cells are skipped and reported separately. A nonblank cell that is not a supported number is an error, so labels cannot silently dilute the average.
How does Summarize a numeric CSV column work?
Parse nonblank selected cells as numbers; calculate count, sum, mean, minimum and maximum using decimal arithmetic.
What are the limits of Summarize a numeric CSV column?
Plain text on your device, with no remote fetch. CSV input is comma-separated with unique nonempty headers, at most 1,000 rows and 50 columns; downloads escape spreadsheet formula prefixes.