Forum Discussion
CountIf question
I have about 20 columns that either have a value between 0 and 25, or might have no value. I want an additional column that can total the 5 previous cells in that row that have a value, but ignore t...
As variant on Excel with dynamic arrays
=SUM(INDEX(FILTER(A1:T1,A1:T1<>""),SEQUENCE(5,,COUNTA(A1:T1),-1)))