The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes. By default, references in Excel use the A1 reference style, which means that it refers to ...

Well-known functions like UNIQUE, COUNTIF, and SORTBY can be used with the spilled range operator to generate dynamic, sortable lists. Using a hash symbol (#)—also known as a spilled range ...

Counting cells in Excel using the COUNT function is very easy, so if you want to learn how to do it, read this post to learn all about it.

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

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.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.