Adding numbers based on partial text in adjacent cells
I need to add the numbers in cells that are next to cells containing specific
text. I can do this with SUMIF, but that requires (I believe) matching the
entire string of text. I want to key on one particular word in that string.
I'm getting lumps from banging my head on the desk. HELP!
|