Ruslan,

Using the Conditional Sum Wizard, I came up with the following array formula
(use Control+Shift+Enter to enter it):

{=SUM(IF(DateCol=DATEVALUE("01/01/2005"),IF(DateCol<=DATEVALUE("31/01/2005"),ValCol,0),0))}

(The curly brackets get added automatically when you press
control+shift+enter)
You can change the dates to make the formula give an answer for a particular
month in a particular year, as the SumProduct example shown elsewhere won't
distinguish between different years.

Now, if someone can show ME how to substute cell references containing start
and end dates for the "DATEVALUE" parts of the formula above, then I@D be
grateful, too!

Hope this helps

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