Total Labour Hours by month

[ExcelRoy]

Hi,

I have been trying to find a formula that totals my labour hours for a particular month of the year from a list of total hours used throughout the year (A simple break down of hours by month)

Column C has all dates
Column D has hours worked
Column E has engineers name

Column I Has month
Column J I need to have a total taken from column D from the month in column I

Hope this all makes sense

Many Thanks

 

[Oeldere]

Use a pivot table for that kind of work.

another solution:

=sumproduct(($I$1:$I$1500="june")*($d$1:$d$1500))

 

[ExcelRoy]

Thanks Oeldere,

I have a question tho

Column C shows dates in dd/mm/yyyy format, how will the "june" be recognized within the list of dates?

Thanks

 

[Oeldere]

You have the months in column I (so use this column I for the formula).

 

[ExcelRoy]

hi oeldere,

Should the formula not look into column C (Date) to be able to add the hours against those dates in June?

How does the formula know to ignore other dates and juts take junes hours?

Thanks for your help

 

[Oeldere]

month is in column I.

Hours are in column D.

So it will find the hours (in D) in the month (in column I).

But again I would advice a pivot table.