Dec 20 2020 06:20 AM
Hi,
I'm currently trying to learn to use CSE / control+shift+enter formulas in workbooks to improve my Excel usage.
I'm trying and well failing to get a simple CSE formula to evaluate. Another simple example such as ={SUM(ColumnA*ColumnB)} to calculate sum products of two columns works as expected.
I'm currently trying to use this formula ={A2:A4*B1:D1}, where A2:A4 and B1:D1 are just three adjacent cells going 1, 2 and 3. For some reason when I try to evaluate this formula use CSE it just doesn't fill out in the workbook. Instead it just calculates the first element in the cell, where the formula was typed in. It shows the formula enclosed {} in curly brackets but it hasn't spilled over the range.
This is of course a simple example I'm not using for a real life job, its just irritating as I can't see why it isn't working.
I've tried looking at my settings to see anything obvious I've missed. I've also tried looking around looking around to no avail. I'm using MS Office 2016.
Any help appreciated, thank you.
Dec 20 2020 07:10 AM
Dec 20 2020 10:01 AM
Hi @tham11265
This is because you just select one cell when you write the formula,
You should select the same number of cells that you will do the operation on, in your case is 3
If you do not select the cells, you will get the result for the first cell
Dec 23 2020 03:15 AM
As a comments, it's better to avoid CSE