View Single Post
  #8  
Old July 8th, 2004, 05:54 PM
Harlan Grove
external usenet poster
 
Posts: n/a
Default Array formula in merged cells

"Frank Kabel" wrote...
some (crude) workarounds:
1. Add several SUMIfs each comparing only to one of the
values in your comparison range

2. Unmerge the cells, enter the formula in the leftmost
cell and merge the cells again

....

One more work-around: enter the formula as defined name, then refer to that
defined name in the merged cell's formula.