That is why using this function is quite time-consuming. However, if you have only ten or twenty rows, you can use this formula to get your job done. Read: How to count Nonblank Cells in Excel.

For example, typing =OFFSET(A1 ... Now, I'll use the COUNTIF function with a wildcard to tell Excel to count how many cells in row 1 contain the word "Week" followed by a number: =COUNTIF(1:1 ...