Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

Image: Paul Barnwell/Shutterstock. The TechRepublic article How to create a sorted unique list in an Excel spreadsheet shows you how to use Excel’s UNIQUE() dynamic array function to create a ...

Functions in Excel give you a deep level of customization for your spreadsheet, and their versatility allows you to craft formulas for nearly any need you may have.

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.

25 Excel Functions for financial modeling; How to use Excel FILES a secret, powerful hidden function; How to use Excel INDEX & MATCH in formulas effectively; How to create Excel Dependent Drop ...

Counting cells in Excel using the COUNT function is very easy, so if you want to learn how then we suggest following the steps laid out here: Open Microsoft Excel; Launch the preferred Sheet; ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.