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

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

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