Need help adding multiple data in different rows

[mikydred]

I am working on a project and I need help. If you take a look at the attached spreadsheet you will find two tabs one called data and the other called result.


What I am trying to do is to add up all the hours worked by a particular employee from the table below.

[pre]

MONTH	EMPLOYEE ID	REGULAR HOURS	EMPLOYEE NAME	EMPLOYEE HOURLY RATE	ACCOUNT NO	ACCOUNT NAME	HOURS
Jan	0101	        40.000    	Rud, Maria	33.7500	1117-002-39	SCSEP	20.00
Jan	0101     	40.000   	Rud, Maria	33.7500	1117-002-39	SCSEP	4.00
Jan	0101    	40.000   	Rud, Maria	33.7500	1117-002-39	SCSEP	8.00
Jan	0102	        20.000   	Hall, Tony	72.8000	1117-002-39	SCSEP	10.00
Jan	0103    	40.000   	Nobles, Khalil	25.0000	1117-002-39	SCSEP	2.00
Jan	0103    	40.000   	Nobles, Khalil	25.0000	1117-002-39	SCSEP	24.00
Jan	0101    	40.000   	Rud, Maria	33.7500	1117-002-39	SCSEP	16.00
And Have it show up in a dirent tab like this:

EMPLOYEE NAME	MONTH	REGULAR HOURS	ACCOUNT NAME	HOURS	RATE
Rud, Maria	Jan	320	SCSEP	80	35.75
Hall, Tony
Nobles, Khalil

[/pre]
Will appreciate a response.


Thank you.

 

[Luke M]

If you create a PivotTable from the first sheet, you could easily get a report that looks like

[pre]

Name         Month   Account Name    Regular Hours    Hours   Rate
Rud, Maria    Jan      SCSEP             320          80        35.75
etc

[/pre]
The first three columns would be in the Row Field area, and the last 3 would be in the data area. You can choose whether to sum/average/max any of those. That would probably be the fastest way to get the report you want.

 

[mikydred]

Thanks look I will give that a try.