Calculate the sum if two different conditions
Closed
                    
        
                    jyotishdev_g
    
        
                    Posts
            
                
            1
                
                            Registration date
            Tuesday June 30, 2009
                            Status
            Member
                            Last seen
            July  1, 2009
            
                -
                            Jul  1, 2009 at 01:58 PM
                        
Mahesh - Oct 8, 2009 at 12:37 AM
        Mahesh - Oct 8, 2009 at 12:37 AM
        Related:         
- Calculate the sum if two different conditions
 - Calculate vat in excel - Guide
 - If cell contains text then return value multiple conditions ✓ - Excel Forum
 - Conditional formatting if cell contains text ✓ - Excel Forum
 - Sum in french excel - Guide
 - Calculate mtu - Guide
 
1 response
                
        
                    venkat1926
    
        
                    Posts
            
                
            1863
                
                            Registration date
            Sunday June 14, 2009
                            Status
            Contributor
                            Last seen
            August  7, 2021
            
            
                    811
    
    
                    
Jul 1, 2009 at 08:15 PM
    Jul 1, 2009 at 08:15 PM
                        
                            
                    in an empty cell type this formula and see 
=SUMPRODUCT(($A$1:$A$5=2)*($B$1:$B$5="a")*($C$1:$C$5))
modify the formula to suit you.
            =SUMPRODUCT(($A$1:$A$5=2)*($B$1:$B$5="a")*($C$1:$C$5))
modify the formula to suit you.
        
    
    
    
    
Jul 2, 2009 at 12:08 PM
Oct 8, 2009 at 12:37 AM