1
votes
=countifs(Kayan!F:F,$E$4,Kayan!K:K,F5,Kayan!L2:AP317,"true")

This formula returns an "array arguments to countif are of different size" error how do I fix it

1

1 Answers

0
votes

try like this:

=COUNTIFS(Kayan!F:F, $E$4, Kayan!K:K, F5, Kayan!L:AP, "true")