How build a summary page

[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

 

[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

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.