Introducing Array Formulas In Excel
If you have experience using formulas in Excel, you know that you can perform some fairly sophisticated operations. For example, you can calculate the total cost of a loan over any given number of years. However, if you really want to master formulas in Excel, you need to know how to use array formulas. You can use array formulas to do the seemingly impossible, such as count the number of characters in a range of cells or sum numbers that meet certain conditions, such as the lowest values in a range or numbers that fall between an upper and lower boundary. This paper introduces array formulas and explains how to enter, edit, and troubleshoot them.