AND function in Excel - Dashboard Guide

Dashboard Mode - AND function

Goal

Check if sales meet multiple conditions: sales above 100 and region is East.

Sample Data

Order ID	Region	Sales
101	East	150
102	West	90
103	East	80
104	North	200
105	East	120

Dashboard Components

• KPI Card: Count of orders where sales > 100 and region is East.
  Formula: =SUMPRODUCT(--(B2:B6="East"), --(C2:C6>100))
  Result: 2
• Table: Add a column "Meets Conditions" with formula:
  =AND(B2="East", C2>100)
  This shows TRUE if both conditions are met, FALSE otherwise.

Dashboard Layout

+----------------------+-----------------------+
|      KPI Card        |    Data Table          |
|  (Count of Orders)   |  (Orders with AND)     |
+----------------------+-----------------------+

Interactivity

Add a filter for Region. When you select "East", the KPI card and table update to show only East region orders. The AND condition recalculates accordingly.

Self Check

Add a filter for Region = "East". Which orders show TRUE in "Meets Conditions" column? How does the KPI card value change?

Key Result

Dashboard shows count and details of orders where sales are above 100 and region is East using the AND function.