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.

First time to stick my toe into this part of the fora! Two Excel questions that I cannot find an answer to here or anywhere else on the internets. I have access to Excel 2007 PC and Excel 2004 Mac ...