as you can see I want to count the filled columns which are filled. I want to create a new row which will show us the filled cells.
1
1
1
1
2
3
2 answers
Hi @Anirudh Madhwa Kaviliga I have already tried that but it is not working. It gives me 1 for every row. I think index affects this situation. I have tried also fixed and window max formulas.