Please very urgent and help

[pol]

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

 

[Bob Phillips]

Excel has built in functionality, Data>Subtotals...

 

[מיכ×ל (מיקי) ×בידן]

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

 

[Ron Rosenfeld]

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