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.

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.

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.

The sum_range is E6:E43 because it contains the amounts to be summed. Put together, the formula is =SUMIF (F6:F43,”FR”,E6:E43), which calculates to $10,023.50, which is the total amount associated ...

This is where the number-crunching fun starts. Learn the ins and outs of the logical formulas that represent the heart of Excel.

After you've assembled all your financial data and created a worksheet to contain your income in one column and your expenses in another, you can use Excel's "SUM" function to create a formula to ...