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
Try SUMIF with a wildcard like this in F23 copied across
=SUMIF($C:$C,"*punch*",AH:AH)
adjust the text for each row
Audere est facere
You can try this one.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Thanks Tsjallie!
Works great!
Cansa
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks