matching multiple criteria for a date

[omer1234]

If I have this data set, how do I know how many times apples appear on A,B,C on a specific date?

Thanks in advance, as I learn these functions

Time Entered

2/27/2024​

2/27/2024​

2/27/2024​

2/27/2024​

2/27/2024​

2/27/2024​

2/27/2024​

2/27/2024​

2/21/2024​

2/21/2024​

2/21/2024​

2/21/2024​

2/21/2024​

2/20/2024​

Shift

A

B

A

B

C

A

C

B

A

B

C

A

C

B

Unit

Apples

Oranges

Tomato

Apples

Apples

Banana

apples

Apples

Banana

Pineapple

\Tomato

Pineapple

Apples

Banana

Apples

A

B

C

2/20/2024​

2/21/2024​

2/27/2024​

 

[Scott Huish]

What version of Excel do you have?

 

[etaf]

=COUNTIFS($B$1:$O$1,$D8,$B$2:$O$2,F$7,$B$3:$O$3,$F$6)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Time Entered	2/27/24	2/27/24	2/27/24	2/27/24	2/27/24	2/27/24	2/27/24	2/27/24	2/21/24	2/21/24	2/21/24	2/21/24	2/21/24	2/20/24
2	Shift	A	B	A	B	C	A	C	B	A	B	C	A	C	B
3	Unit	Apples	Oranges	Tomato	Apples	Apples	Banana	apples	Apples	Banana	Pineapple	\Tomato	Pineapple	Apples	Banana
4
5
6						Apples
7						A	B	C
8				2/20/24		0	0	0
9				2/21/24		0	0	1
10				2/27/24		1	2	2
Sheet1

Cell Formulas
Range	Formula
F8:H10	F8	=COUNTIFS($B$1:$O$1,$D8,$B$2:$O$2,F$7,$B$3:$O$3,$F$6)

 

[omer1234]

=COUNTIFS($B$1:$O$1,$D8,$B$2:$O$2,F$7,$B$3:$O$3,$F$6)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Time Entered	2/27/24	2/27/24	2/27/24	2/27/24	2/27/24	2/27/24	2/27/24	2/27/24	2/21/24	2/21/24	2/21/24	2/21/24	2/21/24	2/20/24
2	Shift	A	B	A	B	C	A	C	B	A	B	C	A	C	B
3	Unit	Apples	Oranges	Tomato	Apples	Apples	Banana	apples	Apples	Banana	Pineapple	\Tomato	Pineapple	Apples	Banana
4
5
6						Apples
7						A	B	C
8				2/20/24		0	0	0
9				2/21/24		0	0	1
10				2/27/24		1	2	2
Sheet1

Cell Formulas
Range	Formula
F8:H10	F8	=COUNTIFS($B$1:$O$1,$D8,$B$2:$O$2,F$7,$B$3:$O$3,$F$6)

Thanks

 

[etaf]

you are welcome
as asked by

Scott Huish​

What version of excel are you using - would be worth updating your profile to show version as solutions will be dependant on what version you have and therefore what functions available