Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

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

SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.

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 ...

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.

You can subtract multiple cells from one cell in Excel by using Minus sign, SUM function and Paste Special feature. Here is a tutorial on this.