by RusselB » Mon Jul 15, 2019 4:44 pm
The COUNT function also does not care the order of the cells in the range.
In fact I can't think of a single spreadsheet function where the order of the range matters.
Counting in sequences of 5, restarting at the next entry for 800 entries is going to be the same count as counting the 800 all at once.
Again, if you can explain what it is you are wanting in the long run, we might be able to save you time from asking for help at each step.
If you do need to count through a looping progression, then a macro is needed.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.