The result obtained from the two procedures is the same.
Step 5: Check the result determining total with the general procedure we used. The result is obtained as shown in the image. Step 4: The opening and closing braces are added to the sum formula. Step 3: After entering the formula, press CTRL SHIFT-ENTER to convert the general formula into an array formula. Step 2: Enter the formula as total = sum (D6:D11*E6: E11) as shown in the below image. Step 1: Place the cursor in the empty cell where you want to produce the worth of the product’s total sales. The following data is considered for this example. This example illustrates the use of Ctrl SHIFT-ENTER in calculating the sum of sales generated for different products.
Use of CTRL SHIFT-ENTER in IF functions.īelow are the examples of excel control shift-enter. Returning the results in multiple and single cells applying the array formulas. Determining the Average, Min, Max, Aggregate, and array expressions. Expanding the array formula to multiple cells. Performing the task of the creation of simple datasets in a short time. Summing the values presented in every nth column or row within low and upper boundaries. Counting the number of characters or values in the range of data in Excel. Replacing the hundreds of formulas with only a single array formula or summing the range of data that meets specific criteria or conditions. Creation of array formula in determining the sum of the set of values. Creation of array formula in matrix operations such as multiplication. You can download this CTRL Shift-Enter Excel Template here – CTRL Shift-Enter Excel Template It is effectively used in various operations like determining sum and performing matrix multiplication.ĬTRL SHIFT-ENTER is used in many applications in Excel. This shortcut works for different functions that require the use of data in a range of cells. CTRL SHIFT-ENTER also works for vertical and multi-dimensional arrays in Excel. This keyboard shortcut works in different versions of Excel, including 2007, 2010, 2013, and 2016. As shown above, braces are enclosed to the formula by resulting in the range of cells in a single horizontal array. Arrays are the collection of the data, including text and numerical values in multiple rows and columns or only in a single row and column. Before we use the shortcut CTRL SHIFT-ENTER, we need to understand more about the arrays. TEXT and String Functions in Excel (26+)Įxcel functions, formula, charts, formatting creating excel dashboard & others Explanation of Ctrl Shift-Enter in Excel. Lookup and Reference Functions in Excel (36+). Excel Conditional Formatting Based on Another Cell Value. 
SUMPRODUCT Function with Multiple Criteria. Compare Two Columns in Excel for Matches.
0 kommentar(er)
