HELP !!! SUMIF or SUMPRODUCT
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 ????????
|