Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ???????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF,SUMPRODUCT | New Users to Excel | |||
SUMPRODUCT or SUMIF | Excel Discussion (Misc queries) | |||
sumif and sumproduct together | Excel Discussion (Misc queries) | |||
Sumif or Sumproduct? Maybe neither? | Excel Worksheet Functions | |||
Sumif or Sumproduct | Excel Worksheet Functions |