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.

Dio wrote:
>
> 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

Look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Dio" <laughing.goat@gmail.com> wrote in message
news:6e3129a4-e114-4990-a022-71bbb6e20d09@l42g2000hsc.googlegroups.com...
> 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?

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



"Dio" <laughing.goat@gmail.com> wrote in message
news:6e3129a4-e114-4990-a022-71bbb6e20d09@l42g2000hsc.googlegroups.com...
> 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?