Menu

Tech

English

Recap: Regional Summary

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 15 of 28.

Challenge

Medium

Using the region/status/sales table in A2:C5 and selected region E2, show its total row count in F2, Paid sales total in F3, and Open sales total in F4.

Enter formulas in the highlighted output cells: F2, F3, F4. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1

	A	B	C	D	E	F	G
1	Region	Status	Sales		Region choice	Result
2	East	Paid	40		East
3	West	Paid	70		Paid sales
4	East	Open	30		Open sales
5	East	Paid	60
6
7
8
9
10
11
12
13
14

All lessons in Formulas and Data Analysis

1Reusable Formulas

Relative References Absolute References Mixed References Rounding Results Recap: Service Invoice

4Lookup Tables

Exact VLOOKUP Exact MATCH Retrieving with INDEX INDEX with MATCH Recap: Product Quote

2Logical Decisions

AND Conditions OR Conditions NOT Conditions Handling Errors Recap: Order Approval

5Cleaning Imported Data

TRIM Spaces SUBSTITUTE Text Finding a Delimiter Converting Numeric Text Recap: Imported Labels

3Conditional Summaries

COUNTIF SUMIF COUNTIFS SUMIFSRecap: Regional Summary

6Final Challenges

Sales Performance Clean Product Search Shipping Decision

Practice on your own: Excel playground