Note also that naming H1:H3 does not change anything regarding the foregoing story. Note that PRODUCT of SUMPRODUCT creates an array values, SUM of SUMPRODUCT sums those values. It is equivalent to entering the formula into one cell, copying the cell, then selecting the cell and pasting. Instead, it is a shorthand way to replicate a formula in a range of cells. Also, there is another way to enter formulas: select a range of cells, and press ctrl+Enter (without shift). Here we don't need control+shift+enter because SUMPRODUCT is designed to operate as an array-processing function whenever it's called. My guess is: if we press ctrl+shift+Enter, it will take Excel longer to process the formula simply because it is expecting to have to process an 'array formula'. Some programs interpret it as 'paste without formatting'. Applying control+shift+enter forces SUM to consider all of the available values and yields the desired value (That is, SUM becomes an array-processing function when combined with control+shift+enter).Дoes return the total of all the conditional values SUMIFS calculates. Answer (1 of 4): That depends, what are you expecting it to do There isnt a 'standard' interpretation of that key combination. SUM will also see just one of the conditional values (or none giving 0). Since we are interested in the sum of these conditional sums, we wrap this SUMIFS expression into a totaling function:

Since these 3 values cannot 'fit' a single cell, we just see the first conditional value (or just one of them or none). This is the default behavior in Excel, and it allows us to quickly work our way down a list when entering data into cells. When editing a cell, pressing the Enter key will select the cell below the cell you are currently working in. Calculates three conditional sums, i.e., for H1, H2, and H3 which is an array of 3 conditional values. Ctrl+Enter is a shortcut I use all the time when entering data or formulas.

Why ctrl shift enter in excel