| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a project name to weekly hours/pay
I want to input one employee's hours/pay for each week of the year. Then in
the next column associate a project name etc. for the whole year. Then at the top page(maybe frozen) I want each project name to pull only the data with its associated name (next to it) for a yearly total. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign a project name to weekly hours/pay
=SUMIF(project_col,project_name,pay_col)
-- __________________________________ HTH Bob "Phoenix Bass" <Phoenix wrote in message ... I want to input one employee's hours/pay for each week of the year. Then in the next column associate a project name etc. for the whole year. Then at the top page(maybe frozen) I want each project name to pull only the data with its associated name (next to it) for a yearly total. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif and translate annual hours into weekly quarter hours | Excel Worksheet Functions | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| create a timesheet to add daily and weekly hours and overtime | Excel Worksheet Functions | |||
| Does anyone have a weekly schedule that computes total hours work | Excel Worksheet Functions | |||
| How do I calculate total weekly hours for payroll in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
