excel lottery

New Contributor

need to know how to count skips in a column want to count skips each time i update it.






3 Replies



This formula, adjusted for the correct top and bottom row, will count empty cells..



However, I want to ask what the nature of this spreadsheet is (if you don't mind): In general, even though it might make reading a spreadsheet easier for the human user, that kind of arrangement of data should be saved for the output or reporting end of things. Having empty rows (or empty cells in a column) of data to be processed in some way or other can make the work that Excel has to do more problematic, potentially more error prone.


what i wanted it to do is number the skips 1234 then skip@mathetes hits then count and number the skips.




the nature of the spreadsheet is if(or function. it tells me how often a number hits and skips b fore it hits again.