aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi Guys,
can you please help me with below report, I need a formula in "Analysis table" which will count number of WFH, PL, UL, SL based on "Report" table. I need count based on criteria Name and Days of week.
For ex - I need a formula which will show me count of "SL" for Mr. A on Monday, Tuesday, Wednesday......
<colgroup><col><col span="4"><col span="8"></colgroup><tbody>
</tbody>
can you please help me with below report, I need a formula in "Analysis table" which will count number of WFH, PL, UL, SL based on "Report" table. I need count based on criteria Name and Days of week.
For ex - I need a formula which will show me count of "SL" for Mr. A on Monday, Tuesday, Wednesday......
A | B | C | D | E | F | G | H | I | J | K | L | M | N |
1 | Report | ||||||||||||
2 | Names | Mr. A | Mr. B | Mr. C | Mr. D | ||||||||
3 | Monday | 11-8 | 7-4 | 7-4 | 7-4 | ||||||||
4 | Tuesday | 11-8 | 7-4 | 7-4 | 7-4 | ||||||||
5 | Wednesday | SL | 7-4 | 7-4 | 7-4 | ||||||||
6 | Thursday | 7-4 | 7-4 | UL | 7-4 | ||||||||
7 | Friday | 7-4 | 7-4 | 7-4 | 7-4 | ||||||||
8 | Monday | SL | PL | 7-4 | 11-8 | ||||||||
9 | Tuesday | 7-4 | 7-4 | 7-4 | 11-8 | ||||||||
10 | Wednesday | WFH | 7-4 | 7-4 | WFH | ||||||||
11 | Thursday | 7-4 | SL | 7-4 | 7-4 | ||||||||
12 | Friday | 7-4 | 7-4 | 7-4 | 7-4 | ||||||||
13 | |||||||||||||
14 | |||||||||||||
15 | Analysis | ||||||||||||
16 | |||||||||||||
17 | Mr. A | Mr. B | Mr. C | ||||||||||
18 | Days | WFH | PL | UL | SL | WFH | PL | UL | SL | WFH | PL | UL | SL |
19 | Monday | ||||||||||||
20 | Tuesday | ||||||||||||
21 | Wednesday | ||||||||||||
22 | Thursday | ||||||||||||
23 | Friday |
<colgroup><col><col span="4"><col span="8"></colgroup><tbody>
</tbody>