About displaying totals and calculated values in Datasheet view

Microsoft Datasheet View

Show All Show All

About displaying totals and calculated values in Datasheet view

You can perform different types of calculations in a list in Datasheet view. You can display aggregate values, such as sum and average, for a column in the list. You can add calculated columns that use a formula to calculate values for each row in the list. You can also use formulas when specifying a default value for a column.

The following illustration shows the Employee-Payroll list in Datasheet view. The list displays the aggregate values in the Total row at the bottom of the list, and a calculated column titled Net Pay.

A list with Total row and a calculated column

The Total row displays a count of the rows in the Name column and the sum of values in the Net Pay column. The Net Pay column uses the formula that is displayed in the ScreenTip to calculate values for each row.

ShowAbout displaying aggregate values

ShowAbout displaying calculated values in a column

ShowAbout using a formula to calculate default values for a column