While working with Excel sheets, it is very common to fill increment cells. Increment cells are cells in which numerical values are arranged with a fixed increment value across a column.

Click the fill handle and drag it down until you cover the desired rage of cells in the column, and then release the mouse button. Excel copies the value in the first cell to the other cells.

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.