![]() ![]() This is double the work! Calculate Total Sales With An Array FormulaĪn Array Formula performs an Excel operation (math, comparative, join or function argument) on an array or range of data. If we had to get the above result using a non-Array Formula we would have to create a helper column which subtracts the Open & Close cells and then enter the MAX formula to reference these results. STEP 4:By pressing F9 on the selected formula array will give you the resulting array of numbers (press CTRL+Z to get out of this mode when you are done checking the formula results): STEP 3: Instead of pressing ENTER to evaluate the formula, you need to press CTRL+SHIFT+ENTER to turn the formula into an Array Formula which will look like this: STEP 2: Subtract one array/range of data from another array/range of data =MAX( D13:D16– C13:C16)
0 Comments
Leave a Reply. |