Building a summary page

  • Thread starter Thread starter jackso95
  • Start date Start date
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 build 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
 
jackso95,
Insert a new sheet, or move an existing sheet (not sheet1,sheet2, or
sheet3) in front of sheet1.
Rename "Summary"
In cell A1 type "Total Sales:"
In cell A3 type "abc"
in cell A4 type "def"
in cell A5 type "ghi"
in cell A6 type "ggg"
in cell A7 type "klm"
in cell A8 type "frt"
Or in the cells of your choosing.
In cell B2 type "Sales"
In cell C2 type "Cost"

In cell B3 (or cell to right of abc) type
"=Sheet1!$B$3+Sheet2!$B$3+Sheet3!$B$3"
If cell B3 on Sheet1 is where you have "1.00"
In Cell C3 (or cell to right of 2.00) type
"=Sheet1!$C$3+Sheet2!$C$3+Sheet3!$C$3"
If there is not an entry on sheet1, then don't put in cell on Summary.
You can type the formula, or you can type the "=" sign and select the cells
that you want to add together.
hth
Dennis
 
Back
Top