Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet - calculating hours per project type
I'm trying to create a monthly timesheet that is based on hours worked on
each project as well as each project type. Column A = project name Column B = drop down list to choose from three project types (below) Column C = total hours per project Below the spreadsheet is "Total hours by Project - Dev _____ Maint_____ Support_____" I'm trying to say =if anything in column B says Dev add the corresponding cell in column C to total all dev hours. I'm so new at excell, if anyone can help it would be appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet - calculating hours per project type
The SUMIF function should work for you:
=SUMIF(B1:B100,"Dev",C1:C100) HTH, Elkar "Klee" wrote: I'm trying to create a monthly timesheet that is based on hours worked on each project as well as each project type. Column A = project name Column B = drop down list to choose from three project types (below) Column C = total hours per project Below the spreadsheet is "Total hours by Project - Dev _____ Maint_____ Support_____" I'm trying to say =if anything in column B says Dev add the corresponding cell in column C to total all dev hours. I'm so new at excell, if anyone can help it would be appreciated |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet - calculating hours per project type
Thank you so much Elkar, I thought that was what I should be doing but I must
have been missing a comma or something. Yours works great so again, my thanks. "Elkar" wrote: The SUMIF function should work for you: =SUMIF(B1:B100,"Dev",C1:C100) HTH, Elkar "Klee" wrote: I'm trying to create a monthly timesheet that is based on hours worked on each project as well as each project type. Column A = project name Column B = drop down list to choose from three project types (below) Column C = total hours per project Below the spreadsheet is "Total hours by Project - Dev _____ Maint_____ Support_____" I'm trying to say =if anything in column B says Dev add the corresponding cell in column C to total all dev hours. I'm so new at excell, if anyone can help it would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Timesheet maximum hours problem | Excel Worksheet Functions | |||
Calculating hours for a timesheet | Excel Worksheet Functions | |||
Timesheet hours will not total. Help. | Excel Discussion (Misc queries) |