Why use array formulas? Array formulas are often referred to | EXCEL FEATURES | BI & AI

Why use array formulas?

Array formulas are often referred to as CSE (Ctrl+Shift+Enter) formulas because instead of just pressing Enter, you press Ctrl+Shift+Enter to complete the formula.
If you have an 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. You can use array formulas to do complex tasks, such as:

Count the number of characters that are contained in a range of cells.

Sum only numbers that meet certain conditions, such as the lowest values in a range or numbers that fall between an upper and lower boundary.

Sum every nth value in a range of values.

Enter an array formula

Select the cells where you want to see your results.

Enter your formula.

Press Ctrl+Shift+Enter. Excel fills each of the cells you selected with the result.