dimanche 28 juillet 2019

Arrayformula to count X when C

I want to count the cells they have o! or %

I want to count them or v witch have in the front cell from the row an o! or %

="o!: "&count(arrayformula(and($D9:H$67="o!",(E8:E67=Or("v","m")))))&", %: "&count(arrayformula(and($D9:H$67="%",(E8:E67=OR("v","m")))))

but nothing works

Aucun commentaire:

Enregistrer un commentaire