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

Hi
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

-----Original Message-----
Here's my formula:

=Sum(sumif(Data1,ProductCode,Data2))

Data1 is a named column containing product codes.
ProductCode is a named array containing the products for

which I wish to
add the sales figures.
Data2 is a named column containing sales figures.

Simple enough...only if it works in a merged cell!!!

Thanks.
.