Problem: Referencing the picture attached, I would like to sum up the first NUMBER (ignores text) that appears along the same row (up to max of 8 cells after the text) whenever the keyword in O2 appears in the bold box (B2:L21). In this scenario, the answer should be 3+5=8. Please help, thanks!
test.jpg
Bookmarks