Hello,
I need help on how to to count a specific value on a range after a lookup. Basically, I want to count the number of values with a condition which is date (Weekend date). Is there a way to lookup the range instead of manually inputting every time I need to count a specific value in range of dates? Also is it possible to make the formula dynamic? I need to calculate data for years.
Example: If WE 8.5 appears on any column, count how many absences under those columns.
<colgroup><col><col><col span="9"></colgroup><tbody>
</tbody>
Output Table here:
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Thanks in advance.
I need help on how to to count a specific value on a range after a lookup. Basically, I want to count the number of values with a condition which is date (Weekend date). Is there a way to lookup the range instead of manually inputting every time I need to count a specific value in range of dates? Also is it possible to make the formula dynamic? I need to calculate data for years.
Example: If WE 8.5 appears on any column, count how many absences under those columns.
WE 8.5 | WE 8.5 | WE 8.5 | WE 8.5 | WE 8.5 | WE 8.12 | WE 8.12 | WE 8.12 | WE 8.12 | WE 8.12 | |
1-Aug | 2-Aug | 3-Aug | 4-Aug | 5-Aug | 6-Aug | 7-Aug | 8-Aug | 9-Aug | 10-Aug | |
Person 1 | Present | Absent | Present | Present | Present | Present | ABSENT | RD | RD | Absent |
Person 2 | Present | Absent | Present | RD | Present | Present | RD | Present | Absent | Absent |
Person 3 | Present | Absent | Present | RD | Present | Present | RD | Present | Absent | Absent |
Person 4 | RD | Absent | Present | Present | RD | Present | ABSENT | Present | Absent | Absent |
Person 5 | RD | Absent | Present | Present | RD | RDS | ABSENT | Present | Absent | Absent |
<colgroup><col><col><col span="9"></colgroup><tbody>
</tbody>
Output Table here:
Absent | Present | Absent | RD | |
WE 8.5 | 9 | |||
WE 8.12 | ||||
WE 8.19 | ||||
WE 8.26 |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Thanks in advance.