Excel Formula using IF and Countif to count number of matching Text in a column

[Jyotirmaya]

=IF(F:F="29.04.2021",COUNTIF(E3:E1000,"ok"))
=IF(F:F="30.04.2021",COUNTIF(D3:D1000,"Afternoon"))

I am using this formula, if column F:F there is text "29.04.2021" then against that row if there are any "ok" in column E:E1000 then it will count the number of "ok" in the designated cell, but sometimes it shows the value and sometimes it shows FALSE, Kindly help me to know what should be change in the code ? or any different code required for the result

Book1
	A	B	C	D	E	F	G	H	I
1	Sl.No.	Name	MobileNo.	Morning/Afternoon	Status	DATE
2								FALSE	FALSE
3				Morning	ok	29.04.2021
4				Afternoon	ok	29.04.2021
5				Afternoon	Not ok	30.04.2021
6				Afternoon	Ok	30.04.2021
7
Sheet1

Cell Formulas
Range	Formula
H2	H2	=IF(F:F="29.04.2021",COUNTIF(E3:E1000,"ok"))
I2	I2	=IF(F:F="30.04.2021",COUNTIF(D3:D1000,"Afternoon"))

 

[Zot]

Something like this?

Book1
	A	B	C	D	E	F	G	H	I
1	Sl.No.	Name	MobileNo.	Morning/Afternoon	Status	DATE
2								2	2
3				Morning	ok	29.04.2021
4				Afternoon	ok	29.04.2021
5				Afternoon	Not ok	30.04.2021
6				Afternoon	Ok	30.04.2021
Sheet1

Cell Formulas
Range	Formula
H2	H2	=COUNTIFS(F3:F1000,F3,E3:E1000,E3)
I2	I2	=COUNTIFS(F3:F1000,F5,D3:D1000,D4)

Oppa, I should have type in the date, OK and Afternoon, but you know how to alter the formula

 

[Zot]

Book1
	H	I
2	2	2
Sheet1

Cell Formulas
Range	Formula
H2	H2	=COUNTIFS(F3:F1000,"29.04.2021",E3:E1000,"ok")
I2	I2	=COUNTIFS(F3:F1000,"30.04.2021",D3:D1000,"Afternoon")

 

[Jyotirmaya]

Thank you @Zot