One major reason Microsoft Excel spreadsheets are ... combinations will skip over any blank row and will not count towards ...

There is a simple function that you can use to put the number of all comma-separated values ... rows, you can use this formula to get your job done. Read: How to count Nonblank Cells in Excel.