SUBTOTAL function in Excel full tutorial. 👉 Take our Excel Course: 🆓 DOWNLOAD Free Excel file for this video: The SUBTOTAL function in Excel is a better alternative to functions like SUM, AVERAGE, ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions.

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Summarizing data is a common task in Excel, and there’s usually more than one way to do so. Susan Harkins explains three ways to return averages for multiple groups. If you have three or more rows of ...