The other day I needed to count the number non-empty cells in a range. I thought I was going to have to write some complex formula. Turns out Excel has a nice function to do just this – COUNTA.
COUNTA(A5:Z5) for example, would count all of the non-blank cells in Row 5 from Columns A through Z.
As you might guess, there is also a function that does the opposite and counts the number of blank cells. Same concept but the function is called COUNTBLANK.
Hope you find this useful some day.