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

Hi,

Try using SUMIF() in cell C2

=SUMIF(B5:B250,B2,E5:E250)

Regards,
Bondi

Try...

=SUMIF(B5:B250,B2,E5:E250)

Hope this helps!

In article ,
Frick wrote:

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.

Thanks for the help. The formula worked fine.


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