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

@gizmo385 

 

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

=COUNTIF(A6:A15,"")

 

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.