Search for a Keyword. Add Value from another cell.
Solved/Closed
                    
        
                    adam73647
    
        
                    Posts
            
                
            2
                
                            Registration date
            Tuesday January  3, 2017
                            Status
            Member
                            Last seen
            January  3, 2017
            
                -
                            Updated by adam73647 on  3/01/17 at 01:58 PM
                        
adam73647 Posts 2 Registration date Tuesday January 3, 2017 Status Member Last seen January 3, 2017 - Jan 3, 2017 at 10:09 PM
        adam73647 Posts 2 Registration date Tuesday January 3, 2017 Status Member Last seen January 3, 2017 - Jan 3, 2017 at 10:09 PM
        Related:         
- Search for a Keyword. Add Value from another cell.
 - How to search for keywords in a pdf - Guide
 - Search for keywords on chrome - Guide
 - 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
 - Add channel keywords youtube - Guide
 - Google search from usa - Guide
 
1 response
                
        
                    Mazzaropi
    
        
                    Posts
            
                
            1985
                
                            Registration date
            Monday August 16, 2010
                            Status
            Contributor
                            Last seen
            May 24, 2023
            
            
                    147
    
    
                    
Jan 3, 2017 at 04:11 PM
    Jan 3, 2017 at 04:11 PM
                        
                    adam73647, Good evening. 
Try to do:
G2 --> DAYCARE
H2 --> =SUMIF(B2:B100, "*" & G2 & "*", C2:C100)
Adapt ranges to your reality.
Is that what you want?
I hope it helps.
            Try to do:
G2 --> DAYCARE
H2 --> =SUMIF(B2:B100, "*" & G2 & "*", C2:C100)
Adapt ranges to your reality.
Is that what you want?
I hope it helps.
        
    
    
    
    
Jan 3, 2017 at 10:09 PM