Row Col C Col D
1 Level 2 6:30 Pm
2 Level 1 12:30 Pm
3 Level 2 12:30 Pm
4 Level 1 6:30 Pm
5 Level 1 12:30 Pm
6 Level 2 6:30 Pm



I need to create a function as follows where both conditions must be true, however the second argument is not being picked up. I have reformatted this function every way I could think of resulting in either a format error or invalid results.

=COUNTIF(C1:C6,”Level 1”)and(D1:D6,”12:30 Pm”)

Expected results: 2

=COUNTIF(C1:C6,”Level 1”)and(D1:D6,”6:30 Pm”)

Expected results: 1