Sumif Excel Function - multiple conditions
Closed
                    
        
                    michaerd
    
        
                    Posts
            
                
            1
                
                            Registration date
            Friday September 14, 2012
                            Status
            Member
                            Last seen
            September 14, 2012
            
                -
                            Sep 14, 2012 at 07:22 PM
                        
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 14, 2012 at 11:53 PM
        venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 14, 2012 at 11:53 PM
        Related:         
- Sumif Excel Function - multiple conditions
- Excel mod apk for pc - Download - Spreadsheets
- Mutator function c++ - Guide
- Excel color function - Guide
- Network card function - Guide
- Hard drive function - Guide
1 response
                
        
                    venkat1926
    
        
                    Posts
            
                
            1863
                
                            Registration date
            Sunday June 14, 2009
                            Status
            Contributor
                            Last seen
            August  7, 2021
            
            
                    811
    
    
                    
Sep 14, 2012 at 11:53 PM
    Sep 14, 2012 at 11:53 PM
                        
                    =SUMPRODUCT(0+($A$1:$A$100="Technician"),0+($B$1:$B$100))+SUMPRODUCT(0+($A$1:$A$100="engineer"),($B$1:$B$100))
                
                
            