Totals
 

Hi

I have a spreadsheet showing the following
Column A - Product codes
Column B - Description
Column C - Quantities

Most of the Procucts codes and Descriptions are repeated several times,
I need to total up items of the same same Product code.
and Description.
The Product code and Description always match.

How do I do this?

thanks

Daniel

Totals
 

Hi, Daniel. Try Subtotals. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Daniel- Sydney" <Daniel- wrote in message
...
Hi

I have a spreadsheet showing the following
Column A - Product codes
Column B - Description
Column C - Quantities

Most of the Procucts codes and Descriptions are repeated several times,
I need to total up items of the same same Product code.
and Description.
The Product code and Description always match.

How do I do this?

thanks

Daniel

Totals
 

Anne

thanks for your help, worked well.

regards

Daniel

"Anne Troy" wrote:

Hi, Daniel. Try Subtotals. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Daniel- Sydney" <Daniel- wrote in message
...
Hi

I have a spreadsheet showing the following
Column A - Product codes
Column B - Description
Column C - Quantities

Most of the Procucts codes and Descriptions are repeated several times,
I need to total up items of the same same Product code.
and Description.
The Product code and Description always match.

How do I do this?

thanks

Daniel

Totals
 

Terrific!
************
Anne Troy
www.OfficeArticles.com

"Daniel- Sydney" wrote in message
...
Anne

thanks for your help, worked well.

regards

Daniel

"Anne Troy" wrote:

Hi, Daniel. Try Subtotals. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Daniel- Sydney" <Daniel- wrote in
message
...
Hi

I have a spreadsheet showing the following
Column A - Product codes
Column B - Description
Column C - Quantities

Most of the Procucts codes and Descriptions are repeated several times,
I need to total up items of the same same Product code.
and Description.
The Product code and Description always match.

How do I do this?

thanks

Daniel