Vlookup with Multiple results

[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?

 

[Dave Peterson]

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.

 

[Don Guillett]

Look in the help index for SUMIF

 

[Ken Wright]

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..........................