View Single Post
  #9  
Old May 12th, 2015, 06:08 PM
Methodician Methodician is offline
Member
 
First recorded activity by OfficeFrustration: May 2015
Posts: 1
Default

Quote:
Originally Posted by vtisix View Post
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.

Last edited by Methodician : May 12th, 2015 at 06:09 PM. Reason: Adding Excel version