Quick Stats · Google Sheets

Get sum, average, and count for any selection in Google Sheets

October 12, 2026 · 4 min read

You select a range of numbers and glance down for the total — and Google Sheets gives you Sum ,Count and few other stats, in the status bar. handdy, but it comes with a catch.

What Sheets gives you — and what it doesn't

Select a range in Google Sheets and the bottom-right corner shows Sum and Count at a glance. Average, Min, and Max are technically in there too — buried in a dropdown you have to open every time, and they vanish the moment you change the selection. It's a read-only glance, not a tool.

Great potential, poor execution.

The manual way

1. Type =SUM(B1:D3) in a scratch cell, read it, delete it.
2. Then =AVERAGE(B1:D3), then =COUNT(), then =MIN() and =MAX().
3. Or open the Explore panel (bottom-right), let it guess what you want, and type/write the existing stats maually!

None of this is hard. All of it is friction — five formulas (and five cleanups) for a number you needed for thirty seconds before a meeting. The status bar's dropdown is better, but it only shows one aggregate family at a time and it's read only .

The sheetXtend way

Quick Stats puts the full picture in the sidebar the moment you select a range. Select B1:D3 and you see, live and side by side:

• SUM — the total
• AVG — the mean
• COUNT — how many values
• MIN / MAX — the spread

Any new selection updated the list without collapsing it, and each field is coppied to the clipboard when clicked!.

When it pays for itself

This is for the hundred small checks a day: is this column's total right? What's the average order value? How many rows actually have data? Where's the outlier pulling the average? Each one is a thirty-second detour with formulas — and a glance with Quick Stats.