Prev: Conditional Formating based on start and end dates
Next: How do I import a file in DTF format into Excel 2007?
From: pol on 31 Mar 2010 08:10
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




From: Bob Phillips on 31 Mar 2010 08:17
Excel has built in functionality, Data>Subtotals...

--

HTH

Bob

"pol" <pol(a)discussions.microsoft.com> wrote in message
news:5E175F7D-1BCC-435B-BFDF-D77FF214C14E(a)microsoft.com...
>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
>
>
>
>


From: מיכאל (מיקי) אבידן on 31 Mar 2010 08:31
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
>
>
>
>
From: Ron Rosenfeld on 31 Mar 2010 10:31
On Wed, 31 Mar 2010 05:10:02 -0700, pol <pol(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: Conditional Formating based on start and end dates
Next: How do I import a file in DTF format into Excel 2007?