View Single Post
  #2   Report Post  
vishu
 
Posts: n/a
Default

Dates are not in date format..convert all date in to date format...then you
can put filter for respective months.

"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