Open an Excel workbook on your PC. You can now close the VBA window and go back to your Excel sheet. Pick a cell, type =AddOdd (B4:B14) and hit Enter to calculate the total odd numbers in a given ...

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.

2. SUM functions. Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers—but it doesn’t just sum.

Various Count Functions in Excel. If your business uses ... (range, criteria). You can use this function, for example, to count the number of clients in cells A2 to A10 whose last name is ...

Open the Excel 2010 spreadsheet containing the information where you want to perform your count. Click on the cell where you want the result of the COUNTIFS function to appear.

Image: PixieMe/Shutterstock. Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions.In many cases, they can replace older, more complex expressions.

The dot operator and trim range function in modern Excel make formulas more dynamic, concise, and error-resistant, reducing the need for manual adjustments like dragging fill handles.

When entering the functions, if you use the selection method to insert references, you will see Excel’s Table structure referencing at work instead of the actual range (array) references that I use.

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.