# Total Labour Hours by month

#### ExcelRoy

##### Well-known Member
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

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Use a pivot table for that kind of work.

another solution:

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

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

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

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?

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.

Replies
1
Views
277
Replies
2
Views
149
Replies
8
Views
284
Replies
1
Views
223
Replies
0
Views
209

1,221,522
Messages
6,160,308
Members
451,637
Latest member
hvp2262

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back