That formula does not require CTRL+SHIFT+ENTER.

Can you tell me precisely what values were in each of the cells when you tried that formula?

Regards