Calculated Rows

This guide walks you through adding summary calculations — like sums, averages, and counts — to the bottom of your sheet columns.

Ask the Agent

The quickest way to add a calculated row:

Add a sum row at the bottom of the revenue column.

The agent applies the calculation and you'll see the result pinned to the bottom of your sheet. You can ask for any supported function — sum, average, min, max, or counts.

Add a Calculation Manually

1. Click any cell in the column you want to calculate. A calculation row appears at the bottom of your sheet, pinned in place so it stays visible as you scroll.

2. Click the calculation cell at the bottom of that column. A dropdown menu opens with your options.

3. Select a function from the dropdown. The result appears immediately in the calculation row.

That's it — three clicks from data to insight.

Available Functions

Sum

Adds all numeric values in the column. Non-numeric cells are ignored.

Average

Returns the mean of all numeric values. Empty and non-numeric cells don't affect the result.

Minimum

Shows the smallest numeric value in the column.

Maximum

Shows the largest numeric value in the column.

Count Empty

Displays how many cells in the column have no value.

Count Non-Empty

Displays how many cells contain a value.

Percent Empty

Shows the percentage of cells with no value.

Percent Non-Empty

Shows the percentage of cells that contain a value.

Switch or Clear a Calculation

To change the function, click the calculation cell again and pick a different option. The result updates immediately.

To remove a calculation entirely, open the dropdown and select the option to clear it.

Good to Know

• Calculated rows stay pinned to the bottom of your sheet. Scroll through thousands of rows and the calculation is always visible.
• Calculations update automatically when data changes — edits, imports, and deletions are all reflected in real time.
• Each column can have its own function. Sum on revenue, average on deal size, count non-empty on email — mix and match.
• Your calculation selections persist across sessions. Close the sheet, come back tomorrow, and they're still there.

Next Steps

• Formulas — compute derived values within individual cells.
• Validations — flag data that doesn't meet your standards.
• Sorting & Filtering — narrow down the data your calculations run on.