Named ranges in Google Sheets - Dashboard Guide

Dashboard Mode - Named ranges

Dashboard Goal

Help a small store manager quickly see total sales and average sales per product using named ranges for easy formula reading.

Sample Data

Product	Sales
Apples	120
Bananas	80
Cherries	150
Dates	90
Elderberries	60

Dashboard Components

• Named Range Setup: Products refers to A2:A6, Sales refers to B2:B6.
• Total Sales Card: Formula: =SUM(Sales) Result: 500
• Average Sales Card: Formula: =AVERAGE(Sales) Result: 100
• Sales Table: Shows products and sales using named ranges for clarity.

Dashboard Layout

+----------------------+----------------------+
| Total Sales: 500     | Average Sales: 100   |
+----------------------+----------------------+
| Product    | Sales    |
|------------------------|
| Apples     | 120      |
| Bananas    | 80       |
| Cherries   | 150      |
| Dates      | 90       |
| Elderberries| 60      |
+------------------------+

Interactivity

Currently static. Named ranges make it easy to update formulas if data grows. Adding filters later can use named ranges for dynamic ranges.

Self Check

If you add a filter to show only products with sales > 100, which components update?

• The Sales Table will show only Apples and Cherries.
• Total Sales and Average Sales cards should update to reflect filtered data if formulas use FILTER with named ranges.

Key Result

Dashboard showing total and average sales using named ranges for clear formulas.