Hi All
I am having a lot of trouble trying to figure out a formula
I have a spreadsheet that is an extract from another system, it has peoples names, dates and hours worked.
In another spreadsheet I need to figure out how many days that they have worked by month.
i wrote a formula to calcualte the days but can't figure out how to automatically find them and add them based on a couple of criteria.
I've attached my spreadsheet
what I want to do is in the actuals sheet, under the month, I want to look for and add all the days that the person in column A has worked for that specific month, i.e. how many days has Adam worked for December.
Appreciate any help you may be able to offer.
Import Sheet
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
Actuals Sheet
<tbody>
</tbody><colgroup><col><col span="4"></colgroup>
I am having a lot of trouble trying to figure out a formula
I have a spreadsheet that is an extract from another system, it has peoples names, dates and hours worked.
In another spreadsheet I need to figure out how many days that they have worked by month.
i wrote a formula to calcualte the days but can't figure out how to automatically find them and add them based on a couple of criteria.
I've attached my spreadsheet
what I want to do is in the actuals sheet, under the month, I want to look for and add all the days that the person in column A has worked for that specific month, i.e. how many days has Adam worked for December.
Appreciate any help you may be able to offer.
Import Sheet
EMP NAME | Work Date | EFFORTS HRS | Days |
Adam | 01-Dec-13 | 7.5 | 1 |
Adam | 02-Dec-13 | 7.5 | 1 |
Adam | 01-Jan-14 | 7.5 | 1 |
Adam | 02-Jan-14 | 7.5 | 1 |
Adam | 01-Feb-14 | 7.5 | 1 |
Adam | 02-Feb-14 | 7.5 | 1 |
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
Actuals Sheet
Dec-13 | Jan-14 | Feb-14 | ||
Adam | ||||
Mike | ||||
James | ||||
John | ||||
Mathew | ||||
Jim | ||||
Luke | ||||
Dianne | ||||
Nick | ||||
Bob |
<tbody>
</tbody><colgroup><col><col span="4"></colgroup>