Apply a formula if a criteria is met

Question

I have a list with 2 columns, A and B.

In A, theres dates, and in B there's values (0 or 1).

How do I write a formula to count every '0' in B if on the same line (column A) the date is the 1st january 2022.

Example:

a, b 
2022-02-01, 0 
2022-01-01, 0 
2021-03-19, 1

Answer:

Counter should be at 1

Answer 1

Try below formula-

=COUNTIFS(A:A,DATE(2022,1,1),B:B,0)