Vlookup with Multiple results

  • Thread starter Thread starter Dio
  • Start date Start date
D

Dio

What if I was doing a timesheet where I have a list of tasks with how
many hours each person worked at each task on one sheet.

On another sheet I want to just list the person's name and a countup
of how many hours total he or she did.

I can understand using vlookup if each person was only listed once,
but is it possible (or is there another equation) for multiple
instances?
 
Maybe you could use =sumif()

=sumif(sheet1!a1:a10,"dio",sheet1!b1:b10)
or
=sumif(sheet1!a1:a10,a1,sheet1!b1:b10)
if a1 contains the name.
 
SUMIF will probably do what you want - Help will give you an example of how
it works.

SUMPRODUCT would also do it but would also allow you to break it down by
task as well as name if required as it supports multiple criteria.

Regards
Ken..........................
 
Back
Top