- Highlight the cells you want to aggregate.
-
Release the mouse button. The Sum, Count, Average and Standard Deviation appear on the status bar.
The Aggregate function uses Floating Point values, so totals are only accurate to 15 total digits.
You can select a row, multiple rows, a column, multiple columns, or any block of cells. Nonnumeric cells included within your selection are ignored.