Excel -formula that excludes names if other colums have info
Closed
                                    
                        SuckatExcel                    
                                    -
                            Jun 19, 2015 at 02:11 PM
                        
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 27, 2015 at 12:57 AM
        venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 27, 2015 at 12:57 AM
        Related:         
- Excel -formula that excludes names if other colums have info
- Count names in excel - Guide
- Number to words in excel formula - Guide
- Crystal disk info - Download - Diagnosis and monitoring
- Date formula in excel dd/mm/yyyy - Guide
- Excel color formula - Guide
2 responses
                
        
                    venkat1926
    
        
                    Posts
            
                
            1863
                
                            Registration date
            Sunday June 14, 2009
                            Status
            Contributor
                            Last seen
            August  7, 2021
            
            
                    811
    
    
                    
Jun 25, 2015 at 01:18 AM
    Jun 25, 2015 at 01:18 AM
                        
                    data is like this D1 to F5
6-Jan 2-Jun a
2-Jun s
d
f
g
the formula is
=COUNTA(F1:F5)-COUNTIFS(D1:D5,"",E1:E5,"")
            6-Jan 2-Jun a
2-Jun s
d
f
g
the formula is
=COUNTA(F1:F5)-COUNTIFS(D1:D5,"",E1:E5,"")
                
        
                    venkat1926
    
        
                    Posts
            
                
            1863
                
                            Registration date
            Sunday June 14, 2009
                            Status
            Contributor
                            Last seen
            August  7, 2021
            
            
                    811
    
    
                    
Jun 27, 2015 at 12:57 AM
    Jun 27, 2015 at 12:57 AM
                        
                    can you upload a small sample file through speedyshar.com and rephrase the question. I shall try.
                
                
             
        
    
    
    
    
Jun 26, 2015 at 12:16 PM
=COUNTIFS(F3:F1436,"=bill*")+COUNTIFS(F3:F1436,"=betty*")
and
=COUNTA(F1:F5)-COUNTIFS(D1:D5,"",E1:E5,"")
I keep getting a "Value" error. :(