CSV group summary

Decimal arithmetic, with the assumptions visible.

Choose one numeric column and optionally one grouping column. Groups use exact text and appear in order of first occurrence. Records includes every record in the group; calculations use only valid numeric values. Blank numeric cells are counted separately. Unsupported nonblank values stop processing unless you explicitly choose to skip them.

Plain signed decimals support up to 30 digits total and 12 fractional digits; currency symbols, commas and exponent notation are unsupported. Sums, minimums and maximums use exact base-10 arithmetic. Averages round halfway away from zero to your chosen number of places. Trailing zeros may be omitted. Groups with no valid numbers have blank calculation fields.

This is an unweighted file summary, not financial, accounting or tax advice. It does not infer currencies, units or the meaning of a record. Use up to 1,000 groups and review the selected column before relying on a total.

Empty physical lines are ignored when reading a CSV. Explicit empty CSV records, such as a row of delimiters or a quoted empty field, are retained. Header names are trimmed and must be unique. Missing trailing cells become empty text. Record counts and issue numbers refer to the records retained after this reading step.