Summing Duplicate Entries in Excel 2000
 

Following is a sample of data exported from our DOS-based
order entry system in CSV format:

PART# QUANTITY LIST SALE
PRICE PRICE

OP-AHS-100 2 Each $46.75 $37.40
OP-AHS-025 1 Each $13.00 $13.00
OP-PRG-100-H 2 Each $44.50 $44.50
OP-PRG-025-H 1 Each $12.50 $12.50
AP-AHS-025 1 Each $75.75 $75.75
AP-PRG-025 1 Each $12.50 $12.50
AP-SSS-025 1 Each $0.00 $0.00
* 0 $0.00 $0.00
* 0 $0.00 $0.00
OP-AHS-500 1 Each $220.50 $220.50
AP-AHS-500 1 Each $945.50 $945.50
OP-CCG-500-H 1 Each $549.50 $549.50
AP-SSS-500 1 Each $0.00 $0.00
OM-AMS-500 1 Each $143.50 $143.50
OM-AMS-100 1 Each $36.00 $36.00
OM-MAN 1 Each $5.50 $5.50
OM-KEY 1 Each $17.50 $17.50
* 0 $0.00 $0.00
* 0 $0.00 $0.00
P2-AHS-500 1 Each $454.75 $454.75
OP-WCC-ILL 1 Each $51.75 $51.75
OP-AHS-100 1 Each $46.75 $46.75
OP-PRG-100-H 1 Each $44.50 $44.50
OP-AHS-100 1 Each $46.75 $46.75
OP-PRG-100-C 1 Each $44.50 $44.50
AP-AHS-100 1 Each $280.25 $280.25
PE-AHS-100 1 Each $46.75 $46.75
PE-AHS-025 2 Each $13.00 $13.00

I need to create a report that sums all identical
PART#/Sale Price entries into a format and total for each
like this:

PART# LIST SALE #ENTRIES QUANTITY
PRICE PRICE

OP-AHS-100 46.75 46.75 2 4
46.75 37.40 1 2

TOTAL: OP-AHS-100 3 6

With over 100 part#, it would be very time consuming to
use SUMIF for each. Is there a way for Excel to look for
identical entry-pairs and sum them? Would Access be a
better tool for this? We currently use a very old version
of Paradox for this assignment and I would like to use a
current program for this task. Thanks for any advice you
can give!

Summing Duplicate Entries in Excel 2000
 

select your data and do
Data=Pivot Table Report

Walk through the wizard - when you get to the layout button, layout your
report.

--
Regards,
Tom Ogilvy

"Ron Williams" wrote in message
...
Following is a sample of data exported from our DOS-based
order entry system in CSV format:

PART# QUANTITY LIST SALE
PRICE PRICE

OP-AHS-100 2 Each $46.75 $37.40
OP-AHS-025 1 Each $13.00 $13.00
OP-PRG-100-H 2 Each $44.50 $44.50
OP-PRG-025-H 1 Each $12.50 $12.50
AP-AHS-025 1 Each $75.75 $75.75
AP-PRG-025 1 Each $12.50 $12.50
AP-SSS-025 1 Each $0.00 $0.00
* 0 $0.00 $0.00
* 0 $0.00 $0.00
OP-AHS-500 1 Each $220.50 $220.50
AP-AHS-500 1 Each $945.50 $945.50
OP-CCG-500-H 1 Each $549.50 $549.50
AP-SSS-500 1 Each $0.00 $0.00
OM-AMS-500 1 Each $143.50 $143.50
OM-AMS-100 1 Each $36.00 $36.00
OM-MAN 1 Each $5.50 $5.50
OM-KEY 1 Each $17.50 $17.50
* 0 $0.00 $0.00
* 0 $0.00 $0.00
P2-AHS-500 1 Each $454.75 $454.75
OP-WCC-ILL 1 Each $51.75 $51.75
OP-AHS-100 1 Each $46.75 $46.75
OP-PRG-100-H 1 Each $44.50 $44.50
OP-AHS-100 1 Each $46.75 $46.75
OP-PRG-100-C 1 Each $44.50 $44.50
AP-AHS-100 1 Each $280.25 $280.25
PE-AHS-100 1 Each $46.75 $46.75
PE-AHS-025 2 Each $13.00 $13.00

I need to create a report that sums all identical
PART#/Sale Price entries into a format and total for each
like this:

PART# LIST SALE #ENTRIES QUANTITY
PRICE PRICE

OP-AHS-100 46.75 46.75 2 4
46.75 37.40 1 2

TOTAL: OP-AHS-100 3 6

With over 100 part#, it would be very time consuming to
use SUMIF for each. Is there a way for Excel to look for
identical entry-pairs and sum them? Would Access be a
better tool for this? We currently use a very old version
of Paradox for this assignment and I would like to use a
current program for this task. Thanks for any advice you
can give!