Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to lookup group of same numbers in spread sheet
Want to lookup same numbers in col A and get total sum from col C
COL PAYEE AMOUNT 37 Region Millworks 1,120.55 18 Hanson Drywall 980.00 9 St. Martin Const 1,600.00 40 D & S Painting 1,006.00 30 Cassidy Mechanical 545.00 37 Stock Lumber 508.98 8 Carpet One 1,542.30 10 DeGeus Tile 2,740.00 37 Menards 139.60 60 St. Martin Const 500.00 9 St. Martin Const 256.00 19 Accord Electric 430.00 38 K & M Glass 1,175.00 41 Carlson Plumbing 1,535.00 54 St. Martin Const 100.00 60 St. Martin Const 233.78 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to lookup group of same numbers in spread sheet
Sort by column A then use Subtotals from the Data menu.
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "saint" wrote in message Want to lookup same numbers in col A and get total sum from col C COL PAYEE AMOUNT 37 Region Millworks 1,120.55 18 Hanson Drywall 980.00 9 St. Martin Const 1,600.00 40 D & S Painting 1,006.00 30 Cassidy Mechanical 545.00 37 Stock Lumber 508.98 8 Carpet One 1,542.30 10 DeGeus Tile 2,740.00 37 Menards 139.60 60 St. Martin Const 500.00 9 St. Martin Const 256.00 19 Accord Electric 430.00 38 K & M Glass 1,175.00 41 Carlson Plumbing 1,535.00 54 St. Martin Const 100.00 60 St. Martin Const 233.78 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Change the sign on all numbers in a spread sheet | Excel Discussion (Misc queries) | |||
HOW TO PREVENT NUMBERS IN SPREAD SHEET FROM ROUNDING | New Users to Excel | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |