Assign a project name to weekly hours/pay

's Computer Specifications

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.

's Computer Specifications

=SUMIF(project_col,project_name,pay_col)

--
__________________________________
HTH

Bob

"Phoenix Bass" <Phoenix (E-Mail Removed)> wrote in message
news:B282D21E-D153-4848-8526-(E-Mail Removed)...
>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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumif and translate annual hours into weekly quarter hours	se7098	Microsoft Excel Worksheet Functions	21	11th Oct 2008 01:37 AM
Hours Weekly To Hours Monthly Problem	=?Utf-8?B?UmF5IFMu?=	Microsoft Access	8	9th Oct 2007 02:14 PM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis	=?Utf-8?B?R3JhaGFt?=	Microsoft Excel Misc	2	28th Jan 2007 08:40 PM
Weekly Hours	=?Utf-8?B?SmF5YmlyZA==?=	Microsoft Access Forms	6	3rd Apr 2006 12:06 AM
Hourly weekly work hours	Rudy	Microsoft Access Queries	1	6th Jan 2004 07:26 AM