Help with Formula

Giganews Newsgroups
Subject: Help with Formula
Posted by:  Need help with sumif
Date: Tue, 16 May 2006

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        
Customer      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 !!!            

Replies