In B5:B250 I have names of different people. In E5:E250 I have data.
What I would like to be able to do, is in cell B2, type the name of a
person then in cell C2 have a formula that searches through Col B,
matches all rows with the name and then sums all the associated data in
Col E, returning that value.

Thanks forthe help.


--
Frick
------------------------------------------------------------------------
Frick's Profile: http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=530001