IFERROR and IFNA in Google Sheets - Dashboard Guide

Dashboard Mode - IFERROR and IFNA

Goal

Find total sales per product and handle errors gracefully when data is missing or incorrect.

Sample Data

Product	Sales Q1	Sales Q2	Sales Q3
Apples	100	150	200
Bananas	80	#N/A	120
Cherries	50	70	#ERROR!
Dates	#N/A	60	90
Elderberries	40	50	60

Dashboard Components

• Total Sales with IFERROR: Calculates total sales per product ignoring errors or missing data.
  Formula example for Apples (row 2): =IFERROR(B2+C2+D2, 0)
• Total Sales with IFNA: Calculates total sales per product but only handles #N/A errors.
  Formula example for Bananas (row 3): =IFNA(B3+C3+D3, 0)
• Summary Table: Shows product names and total sales calculated with IFERROR.
  Formula in E2: =IFERROR(B2+C2+D2, 0) and drag down.
• Error Check Column: Identifies if there is an error in sales data.
  Formula in F2: =IF(ISERROR(B2+C2+D2), "Error Found", "No Error")

Dashboard Layout

+----------------------+----------------------+----------------------+
|      Sample Data     |  Total Sales (IFERROR) | Total Sales (IFNA)   |
|  (Table with products)|  (KPI cards/table)   |  (KPI cards/table)   |
+----------------------+----------------------+----------------------+
| Error Check Column   |                      |                      |
+----------------------+----------------------+----------------------+ 

Interactivity

Add a filter to select a product name. When you pick a product, the total sales with IFERROR and IFNA update to show only that product's data. The error check column also updates to show if that product has errors.

Self Check

If you filter to show only "Bananas", which have a missing value (#N/A) in Q2, what will the total sales show using IFERROR and IFNA formulas? Which error check message appears?

Key Result

Dashboard shows total sales per product handling errors with IFERROR and IFNA formulas.