Adding color creates a great visual effect, but did you know that you can evaluate values by color? Use this technique to turn color into valuable information.

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

SUMIF and SUMIFS function is used to add data or seperate data in a table or column. We dicuss the difference and how to use them.

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.

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.