S.I/Lisp/

COUNTCELLS




=COUNTCELLS(A1:A10)
-> 10

=COUNTCELLS(A1:Z1)
-> 26

=COUNTCELLS(A1:Z10)
-> 260
        



DEFINE(
    COUNTCELLS,
    LAMBDA(
        range,
        SUM(
            COUNTA(range),
            COUNTBLANK(range))))
        



Help us optimize this function