See Help for the SUMIF worksheet function.

Jerry

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