Try

=SUMIF(A:A,"adelle",B:B)

If this post helps click Yes
---------------
Jacob Skaria


"pumpkin" wrote:

Hi there,
I have a table with the hours that employees have worked (as shown below)and
I need to sum all hours. There are numerous entries for each employee and so
I need a formula that will look for the name in column a and then I need to
sum all hours entered in column B next to that name.

Please advise :-)

Name B C D
adelle 22.50 16.00 1.00
Alice 82.25 79.25 0.00
Alice 19.75 18.75 0.00
Alice 19.75 18.75 0.00
Aqsa 35.00 32.25 0.00
Chen 49.75 49.25 1.00
Chen 19.25 17.75 0.00