You could do the calculation with sumproduct, but that would require that you
know which clients traded on which dates. Why not just use a Pivot Table and
let Excel figure that part out as well? Select your data, then Data Pivot
Table. Accept the defaults for data range (Excel data in the highlighted
cells). For the layout, drag client and date to the row fields, and trade
volume to the data field. Assuming that all the trade volume cells have
numbers, Excel will probably default to 'Sum of Trade Volume', which is just
what you need.

"Soultek" wrote:

Hi Experts ,

I have an excel database which shows the following
Column A : Client Identification Number
Column B : Trade date
Column C : Trade Volume
Column D : Reward Miles

The computation of the reward miles is base on Trade Volume/25000, roundown
to nearest hundred, on the condition the trades are done on the same day.

i.e 15151 5th Jan 07 $30000 100 miles
1548 6th Jan 07 $25000 100 miles

however, if the client trade on multiple trades on a single day , the
computation of miles will be based on the consolidated trades of the day

in this scenario ,

i.e 15115 5th Jan 07 $15000
15115 5th Jan 07 $15000
15115 5th Jan 07 $20000
15115 6th Jan 07 $25000

In the above scenario , the client in total traded $50000 on 5th Jan in
which he is entitled to 200 miles and $25000 on 6th Jan , in which he is
entitle to 100 miles

Any way to program the cells to compute in such a manner ????????