How build a summary page

J

jackso95

Example:

Vendor Sales Cost

Sheet1: Walk-in sales
abc 1.00 .50
def 1.00 .50
ghi 1.00 .50

Sheet2: Drive-thru sales
abc 1.00 .50
ggg 1.00 .75
ghi 1.00 .50

Sheet3: Mailorder sales
ggg 1.00 .45
klm 2.00 .80
frt 1.00 .90


How can I create a summary page as follows:

Total Sales:
abc 2.00 1.00
def 1.00 .50
ghi 2.00 1.00
ggg 2.00 1.20
klm 2.00 .80
frt 1.00 .90
 
B

Bob Greenblatt

Example:

Vendor Sales Cost

Sheet1: Walk-in sales
abc 1.00 .50
def 1.00 .50
ghi 1.00 .50

Sheet2: Drive-thru sales
abc 1.00 .50
ggg 1.00 .75
ghi 1.00 .50

Sheet3: Mailorder sales
ggg 1.00 .45
klm 2.00 .80
frt 1.00 .90


How can I create a summary page as follows:

Total Sales:
abc 2.00 1.00
def 1.00 .50
ghi 2.00 1.00
ggg 2.00 1.20
klm 2.00 .80
frt 1.00 .90
Click to expand...
Your best bet is to combine all sheets into one, and add another column to
indicate the type of sale (walk-in, drive-thru, etc.) then you can use
Data-filter, or an advanced filter and/or Dsum formulas to get exactly what
you want.
 
Top