Thread: array error
View Single Post
  #1   Report Post  
BorisS
 
Posts: n/a
Default 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