Home > Software engineering >  Multiple conditionally count in google sheet
Multiple conditionally count in google sheet

Time:07-07

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

enter image description here

  • Related