What Formula to use(VBA will be great to)

Giganews Newsgroups
Subject: What Formula to use(VBA will be great to)
Posted by:  Need help with sumif
Date: Tue, 16 May 2006

Need to find out Total Discount in Sheet 4 in $ Amount

> Sheet1    Customer Level        
> Custom    Level        
> David    Gold        
> James    Silver        
> Brian    Gold        
> Kelly    Silver        
>
> Sheet2    Discount %        
> Product              Product ID    Gold    Silver
> T-Mobile $10    710    10%    8%
> T-Mobile $25    725    15%    13%
> T-Mobile $50    750    17%    15%
> Cingular $10    310    10%    7%
> Cingular $20    320    15%    12%
> Cingular $50    350    20%    18%
>             
> Sheet3    Report        
> Custome    Product              Product ID    Denom
> Brian    T-Mobile $10    710    $10
> Brian    Cingular $20    320    $20
> James    Cingular $50    350    $50
> David    Cingular $10    310    $10
> Kelly    T-Mobile $25    725    $25
> Brian    Cingular $50    350    $50
> James    T-Mobile $25    725    $25
>             
> Sheet4    Summary        
> Customer    Total Sold Value    Total Discount    
> David                            $10
> James                            $75
> Brian                                $80
> Kelly                            $25
>             
> Product has different discount rates            
> Different Customer has different discount rates            
>             
> Please somebody come up with some formula !!!            
> If you could give me VBA code it will be awesome but if not still fine

Replies