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