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.
- Www.google.com search video - Download - Video playback
- Vim search for word - Guide
- How to search a youtube channel - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
1 reply
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
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