If you have valid excel dates in ColA the below will work. In cell C1 enter
the below and copy down as required.

=IF(B1="",SUM(OFFSET(A1,0,1,-(ROW()-MATCH(9^9,$A$1:A1)+1))),"")

--
Jacob


"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