Array formula in merged cells
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
|