Excel INDIRECT Function: Formulas and Examples (2024) Some functions of Excel are simply meant to amaze you. The INDIRECT function is also one of that lot 🙈. Technically speaking, it will not perform any operation, nor will it run any logical tests to return Boolean Values. It is a unique function that’s different from all other functions ...

Apart from storing and manipulating numbers, sometimes, you may want to use Excel to simply count numbers. For example, the number of students in a class, the number of items on a list, etc. To do so, Excel offers two functions, the COUNT and the COUNTA function. Both the said functions are super easy to operate and can prove very handy. 😀

How to Autosum in Excel. The sum is one of the most commonly used Excel operations. And so, Excel offers an in-built button to facilitate quick additions in Excel. 1. Activate the cell where you want to perform the sum. 2. Go to Formulas > Function Library > Auto Sum.

Some other functions of Excel where wildcard characters can come in handy include the SUMIF, IF, and VLOOKUP functions (advanced uses). Need help figuring out where to start learning these functions? You’re just one click away from it. Click here to register for my free 30-minute email course to learn these and many more functions of Excel.