Course Content
Excel Formulas
Excel Formulas
What is Array Formula in Excel
An array formula in Excel lets you perform multiple calculations at once on a set of values whether a single row, column, or a range. It can return one or multiple results depending on usage.
Imagine you have a table with count and value columns. To find the total for each row, the usual approach would be something like this.
Start by entering a formula in the first cell that multiplies the count by a value. This can be done easily. Use the autofill feature to apply the formula to the rest of the cells. While this method works, it is not very convenient.
Instead of this we could use the array formula. For this we have to write formula for only one cell and then it will display result in multiple cells.
The formula is only in one cell but the result is display in multiple ones.
Start by entering a formula that multiplies count Γ value in the first cell, then use autofill to apply it to the rest. While this works, itβs not very convenient.
Instead, you can use an array formula, which requires just one formula and automatically returns results across multiple cells.
Once you remove the blocking line, the results reappear. Array formulas are great for data integrity you can't accidentally overwrite part of their output, even if you press Delete. Excel protects the entire array.
Thanks for your feedback!
