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

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

The Sort Excel function is a powerful tool for organizing and arranging your data in a meaningful order. Whether you need to sort numbers, text, or dates, this function has you covered.

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.

=SUM() The first function anyone should know tells Excel to carry out basic arithmetic. Let’s say you wanted the numbers in cell A2 and cell B2 to be added together in cell C2.

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.

As a stand-alone function, UNIQUE() returns a list of unique values using the syntax. UNIQUE(array, [by_col], [exactly_once]) The array argument is the Excel range you want to reduce to a unique list.