vlookup and sum- to lookup a name and return and sum of all instan

P

pumpkin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top