COUNTA function with multiple criteria counts how many arguments are in the list of arguments. Learn how to use COUNTA function in Excel.

DGET has only three arguments, making it much more straightforward to use than other Excel lookup functions. The DGET function is an old-school tool!

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

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.