Extracting 1 or 3 from data

[omer1234]

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

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​

 

[Fluff]

Trust me this is not a duplicate post !!!!!!

IMO it is, you just keep making slight changes to the values.
Closed