0
0
Google Sheetsspreadsheet~8 mins

SUMIF and SUMIFS in Google Sheets - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - SUMIF and SUMIFS
Goal

Find total sales based on conditions like product type or region to understand which products or areas perform best.

Sample Data
Order IDProductRegionSales
1001ApplesEast120
1002BananasWest150
1003ApplesWest200
1004OrangesEast100
1005BananasEast180
1006OrangesWest130
1007ApplesEast170
Dashboard Components
  • Total Sales for Apples
    Formula: =SUMIF(B2:B8, "Apples", D2:D8)
    Result: 490 (120 + 200 + 170)
  • Total Sales in East Region
    Formula: =SUMIF(C2:C8, "East", D2:D8)
    Result: 570 (120 + 100 + 180 + 170)
  • Total Sales for Bananas in East Region
    Formula: =SUMIFS(D2:D8, B2:B8, "Bananas", C2:C8, "East")
    Result: 180
  • Total Sales for Oranges in West Region
    Formula: =SUMIFS(D2:D8, B2:B8, "Oranges", C2:C8, "West")
    Result: 130
Dashboard Layout
+---------------------------+---------------------------+
| Total Sales for Apples    | Total Sales in East Region|
|           490             |            570            |
+---------------------------+---------------------------+
| Total Sales for Bananas in East Region | Total Sales for Oranges in West Region |
|               180                    |                130                   |
+-------------------------------------+-------------------------------------+
Interactivity

Add a filter dropdown for Product and Region. When you select a product or region, all totals update to show sales only for the chosen filters. For example, selecting "Apples" updates the total sales cards to only count Apples. Selecting "West" updates totals to only count sales in the West region.

Self Check

If you add a filter for Region = West, which components update and what are their new values?

  • Total Sales for Apples: 200 (only Apples in West)
  • Total Sales in East Region: 0 (East region filtered out)
  • Total Sales for Bananas in East Region: 0 (East region filtered out)
  • Total Sales for Oranges in West Region: 130 (Oranges in West)
Key Result
Dashboard shows total sales by product and region using SUMIF and SUMIFS formulas.