Finding a word in multiple rows and columns, returning sum

**weeble33** · 12-31-2012, 04:42 PM

Hello,

I have some sets of data that aren't all in the same row or column. See below.

A B C D
ab 2 bg 5
ig 3 he 2
lk 1 ig 9

(Blank Row)

ab 4 op 3
fs 2 ig 5

And there's more than 2 sets as shown here. But there it does always follow that Column X is names, Column X+1 is qty. So I would like to type "ab" in say A50, and in B50 it would return 6. and "ig" would return 17. I would like to do this via formula and not have to modify or move my original data around. Thank you.

**FDibbins** · 12-31-2012, 05:27 PM

perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).

try using countif() though, and see how far you get?