Create Summary of the Data Excel Spreadsheet

Create Summary of the Data.

	A	B	C
1	Emp	Month	Expense
2	Smith	Jan	1000
3	Jones	Jan	1500
4	Smith	Feb	800
5	Jones	Feb	1000
6	Smith	Mar	500
7	Jones	Mar	800
8	Smith	Apr	1000
9	Jones	Apr	800
10	Smith	May	945
11	Jones	May	700
12	Smith	June	1000
13	Jones	June	1500
14

Steps:

1. Locate Define name or Name Manager(Create New) option in menu or ribbon bar. 
   
2. 
3. Give the name EMP and select RANGE (ex: A2:A13). And Click OK/Save
4. Give the name Month and select RANGE (ex: B2:B13). And Click OK/Save
5. Give the name Expense and select RANGE (ex: C2:C13). And Click OK/Save
6. Use SUMIF Function Parameter 1: Range Name, Parameter 2: Condition/Criteria, Parameter 3: Range for summary or calculation. (Ex =SUMIF(Emp,”=Smith”, Expense)).