Adding data from multiple rows
 

Here is my delima

In column one, a person can input their ID number. In Column two, they
input hours of work.
Now there are multiple employees using the same sheet. What I want to
do is create a formula that adds all the values in column two that
correspond with each id number.

In other words, I want to make a formula that groups all the values
from the same ID number and adds them up.

Eventually I want to make a list that summarizes by employee id their
total hours worked.

Any sugguestions?

Adding data from multiple rows
 

You could use a tool called pivot tables in Excel. Simply click anywhere in
the list, assuming there are no blabnk rows

Choose Data Pivot Table
Choose Next
Choose Next
Choose Layout button if in older version of Excel
Drag ID to row area
Drag hours to data
Choose OK
Decide on Location and choose finish

or furmual driven, use the Sumif Function . See the Excel formula help for
this

Eddie


"PCStechnical" wrote:

Here is my delima

In column one, a person can input their ID number. In Column two, they
input hours of work.
Now there are multiple employees using the same sheet. What I want to
do is create a formula that adds all the values in column two that
correspond with each id number.

In other words, I want to make a formula that groups all the values
from the same ID number and adds them up.

Eventually I want to make a list that summarizes by employee id their
total hours worked.

Any sugguestions?

Adding data from multiple rows
 

One problem I have with the pivot table is that it is not
automatic/won't automatically update. I'm using this program for
employees who, needless to say, need as much dummy proofing as
possible. Asking them to refresh something may be above them.

Will the sumif function work if I don't know what they are inputing for
their id's? There can be an endless possibility of id's. I just want
something that can put all the same ones together and add it up.

Thanks for the help
Eddie Holder wrote:
You could use a tool called pivot tables in Excel. Simply click anywhere in
the list, assuming there are no blabnk rows

Choose Data Pivot Table
Choose Next
Choose Next
Choose Layout button if in older version of Excel
Drag ID to row area
Drag hours to data
Choose OK
Decide on Location and choose finish

or furmual driven, use the Sumif Function . See the Excel formula help for
this

Eddie


"PCStechnical" wrote:

Here is my delima

In column one, a person can input their ID number. In Column two, they
input hours of work.
Now there are multiple employees using the same sheet. What I want to
do is create a formula that adds all the values in column two that
correspond with each id number.

In other words, I want to make a formula that groups all the values
from the same ID number and adds them up.

Eventually I want to make a list that summarizes by employee id their
total hours worked.

Any sugguestions?