Forum Discussion
Error when using SEQUENCE within COUNTIF
Excel won't accept this formula, and I don't know why: COUNTIF(SEQUENCE(20); "<9") Wrapping it with like the following is accepted by Excel, but produces 20 rows of VALUE errors: LET( ...
COUNTIF() needs a reference and not an array.
This works:
Formula in A1
=SEQUENCE(20)Formula in B1
=COUNTIF(A1#,"<9")
Or you could use mathematical logic:
=9-1
