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.

How to Divide Two Numbers in One Cell for Microsoft Excel. If your Excel cell or row contains two or more values, you can split that data across multiple cells. For Excel to divide the values ...

Whether you prefer Excel, Numbers, or Google Docs, here's what you, the savvy spreadsheet user, should know how to do.