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