I might be a little tired but I cannot find the answer
I got a long array: a single row of 60 cells
I need to do this function on a part of the array COUNTIF(O60:BV60;0)
But I need to tell the funktion if someone types e.g. 9 in a cell that the array is now “O60:Y60”
(other time it hava to searh the long array)
I don’t know how 9 gets you to O60:Y60 but the OFFSET function might do what you need.
Metoo
What I’m searching - cut to the bone - is to do this - COUNTIF(A1:A(1+9)) (move the reference in the last A1 nine cells) = COUNTIF(A1:A10) IF i am sending 4 then it is COUNTIF(A1:A5)
Hallo
but from O to Y the “width in Columns is 11 but not 9”
=COUNTIF(OFFSET($O$60;0;0;1;11);0)
or replace the literal 11 with the Celladress where you input the 11