CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Kasfiq
Kasfiq

Reputation: 3

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

=COUNTIFS(J1:J20,"Done*",L8:L200,(ArrayFormula(month(L1:L20)),(MONTH(TODAY())-1)))

Here is data screenshot

Upvotes: 0

Views: 53

Answers (1)

Harun24hr
Harun24hr

Reputation: 37135

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

Upvotes: 1

Related Questions