How to use ARRAY FORMULA with COUNTIF-CodePudding

Home > front end > How to use ARRAY FORMULA with COUNTIF

How to use ARRAY FORMULA with COUNTIF

Time：05-11

Just want to get this in array formula but I don't know how to script this is the sample

=countif(G7:X7,"A") (countif(G7:X7,"L")/2)

CodePudding user response：

try:

=ARRAYFORMULA(MMULT(IF(C5:J9="A", 1, IF(C5:J9="L", 0.5, 0)), 
 SEQUENCE(COLUMNS(C5:J9), 1, 1, )))