SUM'ing hours for certain workers

B

Beaun

I have a worksheet going for hours worked on a project to get an idea of
cost. I have a collumn for names (verrified list) and a collumn for hours
worked. My question is how do I go about creating a SUM cell for individual
workers.

So I want to SUM "Total Time" (collumn E) for worker X (listed in Collumn A)
so "I can then multiply by pay rate. Thanks for the help.
 
L

Luke M

You probably want to use the SUMIF function. If your names are in column C,
hours in column D, then something like:
=SUMIF(C:C,A2,D:D)
 
B

Beaun

That was what I was looking for. Couldn't find it in the help for some
reason, I'm usually good at finding out how to do stuff with the help, but
this one eluded me. Thanks for the answer.
 

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