SUM function in Google Sheets - Dashboard Guide

Dashboard Mode - SUM function

Goal

Find the total sales amount from a list of sales numbers to understand overall performance.

Sample Data

Item	Sales
Apples	100
Bananas	200
Cherries	150
Dates	50
Elderberries	300

Dashboard Components

• Total Sales Card: Shows the sum of all sales.
  Formula: =SUM(B2:B6)
  Result: 800
• Sales Table: Displays each item and its sales amount for detail.

Dashboard Layout

+-------------------+-------------------+
|   Total Sales     |                   |
|      800          |                   |
+-------------------+   Sales Table     |
|                   | +-----------------+
|                   | | Item      Sales  |
|                   | | Apples    100   |
|                   | | Bananas   200   |
|                   | | Cherries  150   |
|                   | | Dates     50    |
|                   | | Elderberries 300|
+-------------------+-------------------+

Interactivity

If you add a filter to select specific items, the Total Sales card updates to show the sum of only the filtered sales. The Sales Table also updates to show only the selected items.

Self Check

Add a filter to show only items with sales greater than 100. Which components update and what is the new total sales?

Answer: The Total Sales card updates to sum only Bananas (200), Cherries (150), and Elderberries (300), showing 650. The Sales Table shows only these three items.

Key Result

Dashboard showing total sales sum and detailed sales list with filter interaction.