Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLookup Multiple Data Rows alexdwsn Excel Worksheet Functions 2 June 9th 06 12:24 PM
Select rows of data in a worksheet on one criteria in multiple co MrSkoot99 Excel Worksheet Functions 5 July 11th 05 02:48 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 14th 05 12:33 AM
Select all data, multiple rows George Wilson Excel Discussion (Misc queries) 6 December 5th 04 09:16 PM
Lookup values in a list and return multiple rows of data Amanda L Excel Worksheet Functions 2 December 2nd 04 05:48 PM


All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"