Hi Pol I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 56 towards the top of my home page.

This file is prepared in EXCEL 2007.

1. I have copied your data into Sheet2.

2. In Sheet2 you will notice that I have changed column A so that dates
appear in all of the rows.

3. Now take the following action in Sheet2:-

- highlight A1:B12

- Data / Outline group / Subtotal /

Subtotal pane should launch.

4. The Subtotal pop up window should now appear as follows:-

(i) At each change in:

Date

(ii) Use function:

Sum

(iii) Add subtotal to:

Amount

The above field should have a tick in the box on the left.

5. Click OK in the above window.

Adjust column widths.

You should now get the subtotals that you require.

If my comments have helped please hit Yes.

Thanks.


"pol" wrote:

Hi all, I have an excel with the following format. I have to find out
subtotal of the each date column. The empty date column should be considered
under the group of previous column having date. Please help

Date Amount
A1 B1 C1
01.01.2010 2000 Cumi.Sum
-200
-300
-1500 0.00

10.01.2010 500
-300
-200 0.00

20.01.2010 700
-200 500.00

30.01.2010 400
-400 0.00



With thanks and regards

Pol