Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Click one of the column headers in the document that has values. The word "Count" appears in the status bar's bottom right corner. The number of cells that contain values appears next to that word.