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

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.