Look UP Formula
 

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

Look UP Formula
 

Hi,

Try using SUMIF() in cell C2

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

Regards,
Bondi

Look UP Formula
 

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.

Look UP Formula
 

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