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

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