Hi Everyone,

Currently I'm working on a Shared document and I'm trying to figure out a formula that will search for a specific word within the cells of Column C, I'm wanting the formula, to use that word to determine which cells to sum up in Column AH, AI, AJ, and AK...Attached I have the document i am currently working on, there is a table below the data (E22:I28) that indicates the words in "" that need to be totaled..

regards,
cansa

Heres the Attachment..
Search Word Formula B.O.M.xlsm