Look UP Formula

[Frick]

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.

[Bondi]

Hi,

Try using SUMIF() in cell C2

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

Regards,
Bondi

[Domenic]

Try...

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

Hope this helps!

In article <[email protected]>,
Frick <[email protected]> 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.

[Frick]

Thanks for the help. The formula worked fine.