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)))
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)))