IF function in Google Sheets - Dashboard Guide

Dashboard Mode - IF function

Goal

We want to quickly see if sales targets were met for each salesperson. The dashboard will show who met the target and the total count of successes.

Sample Data

Salesperson	Sales	Target
Alice	120	100
Bob	90	100
Charlie	150	100
Diana	80	100
Eva	110	100

Dashboard Components

• Status Column: Shows if each salesperson met the target.
  Formula in cell D2 (copy down): =IF(B2>=C2, "Met", "Not Met")
  Example: For Alice, sales 120 >= target 100, so result is "Met".
• Total Met Count: Counts how many met the target.
  Formula in cell F2: =COUNTIF(D2:D6, "Met")
  Result: 3 (Alice, Charlie, Eva)
• Total Not Met Count: Counts how many did not meet the target.
  Formula in cell F3: =COUNTIF(D2:D6, "Not Met")
  Result: 2 (Bob, Diana)

Dashboard Layout

+----------------------+-----------------+
| Sales Data Table     | Status Column   |
| (A1:C6)              | (D1:D6)         |
+----------------------+-----------------+
|                      |                 |
|                      |                 |
+----------------------+-----------------+
| Total Met: (F2)      | Total Not Met:  |
|                      | (F3)            |
+----------------------+-----------------+

Interactivity

Currently, this dashboard is static. You can add filters later to select specific salespeople or sales ranges. When filters are applied, the Status column will show only filtered rows, but the total counts will not update to reflect only visible rows because COUNTIF counts all rows regardless of visibility.

Self Check

If you add a filter to show only salespeople with sales >= 100, which components update to reflect only filtered data?

• Status Column: Yes, shows only filtered rows (all "Met").
• Total Met Count: No, still 3.
• Total Not Met Count: No, still 2.

Key Result

Dashboard shows which salespeople met their sales targets and counts of successes and failures.