COUNT and COUNTA functions in Google Sheets - Dashboard Guide

Dashboard Mode - COUNT and COUNTA functions

Dashboard Goal

Understand how many cells contain numbers and how many cells are not empty in a list of sales data.

Sample Data

Item	Sales
Apples	100
Bananas	200
Cherries
Dates	150
Elderberries	abc
Figs	300
Grapes

Dashboard Components

• KPI Card 1: Count of Number Sales
  Formula: =COUNT(B2:B8)
  Result: 5 (counts only cells with numbers: 100, 200, 150, 300, and 150)
• KPI Card 2: Count of Non-Empty Sales Cells
  Formula: =COUNTA(B2:B8)
  Result: 5 (counts all cells that are not empty, including text 'abc')
• Data Table: Shows original sales data for reference.

Dashboard Layout

+----------------------+-------------------------+
|  Count of Number      |  Count of Non-Empty     |
|  Sales (KPI Card 1)  |  Sales (KPI Card 2)     |
|        [ 5 ]          |         [ 5 ]           |
+----------------------+-------------------------+
|                                                      |
|                Sales Data Table                      |
|                                                      |
+------------------------------------------------------+ 

Interactivity

Add a filter to select only items with sales greater than 100. Both KPI cards and the data table update to show counts and data only for filtered items.

Self Check

If you add a filter to show only items where sales are numbers greater than 150, which components update and what are their new values?

• KPI Card 1 (Count of Number Sales): Updates to 2 (200 and 300)
• KPI Card 2 (Count of Non-Empty Sales Cells): Updates to 2 (only 200 and 300 cells remain non-empty)
• Data Table: Shows only rows for Bananas and Figs

Key Result

Dashboard shows count of numeric sales and count of all non-empty sales cells from a sales list.