Multiple conditionally count in google sheet

I am trying to count thous cells which have status=Done and Date = Jun 2022 in google sheet. Here I made a formula but not getting proper count value


Here is data screenshot

>Solution :

Try below formula-

=COUNTIFS(A2:A,"Done",B2:B,">=" & DATE(2022,6,1),B2:B,"<=" & EOMONTH(DATE(2022,6,1),0))

enter image description here

Leave a Reply