Hi,
Trust me this is not a duplicate post !!!!!!
Given this data set, How do I extract the number of times "1" is recorded on a specific date..... OR "3" but I am assuming it will be the same formula just different cells
Thanks
Trust me this is not a duplicate post !!!!!!
Given this data set, How do I extract the number of times "1" is recorded on a specific date..... OR "3" but I am assuming it will be the same formula just different cells
Thanks
B-Team | B-Team | B-Team | C-Team | B-Team | B-Team | B-Team | A-Team | |||
02/27/24 13:30:43 | 03/01/24 00:00:00 | 02/27/24 12:45:18 | 02/02/24 00:00:00 | 02/27/24 11:00:03 | 02/02/24 00:00:00 | 02/27/24 12:30:24 | 03/01/24 00:00:00 | |||
3.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
3.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | |||
3.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | |||
0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | |||
0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | |||
3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
Criteria | 1.00 | Criteria | 3.00 | |||||||
A-Team | B-Team | C-Team | D-Team | A-Team | B-Team | C-Team | D-Team | |||
27-Feb | | |||||||||
1-Mar | ||||||||||
2-Feb | ||||||||||