Hello everyone,
Here is my problem, I have the following spreadsheet:
<tbody>
</tbody>
The data in it has to be used in another spreadsheet which looks like that:
<tbody>
</tbody>
I need to fill for each person the number of "F", "IC", "O",... for a given period.
I tried to use a COUNTIFS function but didn't succeed (it only gives me the number of occurences for a given period, I can't link it with specified people).
I hope to be clear.
Any help ?
Thanks a lot.
Here is my problem, I have the following spreadsheet:
A | B | C | NC | |||
1 | Name | 01/01/19 | 01/02/19 | 12/31/19 | ||
2 | Franck | F | IC | O | ||
3 | Larry | O | O | F | ||
500 | Patricia | F | F | IC |
<tbody>
</tbody>
The data in it has to be used in another spreadsheet which looks like that:
A | B | C | D | E | F | |
1 | Name | Start Date | End Date | F | IC | O |
2 | Louis | 01/18/19 | 02/15/19 | |||
3 | Sam | 06/12/19 | 06/24/19 | |||
500 | Larry | 05/28/19 | 07/03/19 |
<tbody>
</tbody>
I need to fill for each person the number of "F", "IC", "O",... for a given period.
I tried to use a COUNTIFS function but didn't succeed (it only gives me the number of occurences for a given period, I can't link it with specified people).
I hope to be clear.
Any help ?
Thanks a lot.