Quote:
Originally Posted by vtisix
I have a simple array formula that sums 3 criterias. After I've entered
the formula and do Ctrl+Shift+Enter, an error pops up stating that
"Array Formulas are not valid in merged cells.".
I am a novice to array formulas so this is strange to me. Any way
around this?
Thanks,
VT
|
While I realize this question was posted years ago, for anyone else I FOUND THE ANSWER.
Intuitively, I tried hitting merge and center AFTER entering the array formula and it works fine. Just unmerge the cells, enter your array formula, hit Ctrl+Shift+Enter, then re-do the merge and center.
It's not awesome to take extra steps but it seems to work fine.
FWIW this is in Excel 2010.