View Single Post
  #2  
Old July 8th, 2004, 04:42 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default Array formula in merged cells

Hi
easiest way: remove the merged cells. I would assume you
have entered this formula in a merged cell?

-----Original Message-----
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
.