On Fri, 7 Feb 2025 at 09:43, Wade Smart <[email protected]> wrote: > > > What I have unsuccessfully been trying to do is. > > SUM(CD6:CD15) + If within this range C6:C13 the string "Upper Swing Pin" > is found, reference BG6:BG13 on whatever line that string was found and > find the text "lb:" and grab the number to the right * BZ that row number > and .. add back to the sum, which is BN17 > > I have had problems from the start. > In my sample worksheet C7 = Upper Swing Pin 272s 725w > When I use Search or Find "Upper Swing Pin" it is not found. > > I was testing with this: > > > =IF(ISERROR(SEARCH("Upper Swing Pin", C6:C13)), "Not Found", "Found") > =IF(ISERROR(SEARCH("Upper", C6:C13)), "Not Found", "Found") > > > both said not found.
My understanding is the the SEARCH function is for finding a string of text **within** another text, not across a range of cells. ISTM it will be necessary to do a FIND function for each individual cell where the text might be located. -- T. R. Valentine A rich heart may be under a poor coat. -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
