I have an excel with the following column

company Customer currency amount
1 AA ST 12
1 BB ST 2.50
1 BB EU 3.50

2 CC ST 12.00
2 DD EU 6

I want to get the subtotal for each company and currency type both . How I
can give subtotal as follows

Please help

Excel has built in functionality, DataSubtotals...

--

HTH

Bob

"pol" wrote in message
...
I have an excel with the following column

company Customer currency amount
1 AA ST 12
1 BB ST 2.50
1 BB EU 3.50

2 CC ST 12.00
2 DD EU 6

I want to get the subtotal for each company and currency type both . How I
can give subtotal as follows

Please help

You can choose between a Formula and Pivot-Table:
http://img130.imageshack.us/img130/4892/nonamem.png
Micky


"pol" wrote:

I have an excel with the following column

company Customer currency amount
1 AA ST 12
1 BB ST 2.50
1 BB EU 3.50

2 CC ST 12.00
2 DD EU 6

I want to get the subtotal for each company and currency type both . How I
can give subtotal as follows

Please help

On Wed, 31 Mar 2010 05:10:02 -0700, pol wrote:

I have an excel with the following column

company Customer currency amount
1 AA ST 12
1 BB ST 2.50
1 BB EU 3.50

2 CC ST 12.00
2 DD EU 6

I want to get the subtotal for each company and currency type both . How I
can give subtotal as follows

Please help





I would use a Pivot Table (Insert/Pivot Table)

Drag Company to Rows
Currency to Columns
amount to Values or Data

ReLable appropriately and format to taste.

e.g:

Amounts Currency
Company EU ST Grand Total
1 3.50 14.50 18.00
2 6.00 12.00 18.00
Totals 9.50 26.50 36.00
--ron