Hello vislavti,

A formula is entered with Ctrl+Shift+Enter when the operation is applied to multiple cells simultaneously.Formulas that operate on more than one cell are know as array formulas. You must enter array formulas with Ctrl+Shift+Enter and drag them down the range to see the individual results. If you don't then only the first result is returned.