Hi Excel Team,
In Column A I have values like this from row 5 to 35 for instance:
5
6
blank
7
8
blank
blank
2
I would like to count the number of non-blank value and return that in A1... so I use =COUNT(A5:A35)
but the next day, i have a new value in cell A36, so now i would like A1 to count A6:A36..always counting back 30.. from the last value in column A
How do i amend my excel A1 formula ?
In Column A I have values like this from row 5 to 35 for instance:
5
6
blank
7
8
blank
blank
2
I would like to count the number of non-blank value and return that in A1... so I use =COUNT(A5:A35)
but the next day, i have a new value in cell A36, so now i would like A1 to count A6:A36..always counting back 30.. from the last value in column A
How do i amend my excel A1 formula ?