Ruslan,

Found it!

Assuming your dates are in a range "DateCol"
and the values are in a renge "ValCol"
your start date is cell H3
your end date is cell I3

the array formula you require is:

{=SUM(IF(DateCol=H3,IF(DateCol<=I3,ValCol,0),0))}

Remember to hold down Control+Shift while pressing Enter

You can then copy this formula to other cells to calculate totals for other
months.

Thanks for the challenge!

Pete




"Ruslan" wrote:

Dear All,
I have the following data:

Data Amounts

01.01.05 1000
02.01.05 2000
10.01.05 14000
01.02.05 3000
12.02.05 2500
... etc. ..etc.

I need to calculate the sum of all amounts in january, february, march,
etc...separately....
in other words, ...if data is within january then sum of january's amounts
and so on...
I appreciate you help in advance,
Ruslan