array error
I am having trouble with an array. I have a summary set of cells and four
identical sets that need to sum into it (to be clear, I need each of the
summary array cells to sum their respective cells from the four identical
areas).
I am selecting the sum cell group, entering 'Sum(first range, second range,
third range, fourth range)' (with none of those being named ranges...just
starting cell to ending cell), and then doing ctrl-shift-enter. The result I
am getting is the same in each of the sum cells, even though the input cells
are clearly all different. What am I doing wrong?
--
Boris
|