A new wrinkle: Using SUMIF I'm able to do the calculations using the entire
text string (I still want to key in on one word though) on a single sheet. I
need to do the calculation across 24 sheets. When I choose a range across
multiple sheets, I get a #VALUE error "A value used in the formula is of the
wrong data type". Each individual sheet works fine. I only get the error
when I try to check two or more sheets.

"s31064" wrote:

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!