Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplifying array formula which evaluates as error. | Excel Worksheet Functions | |||
Error 1004 using array in Sheet select. | Excel Discussion (Misc queries) | |||
Trouble shooting#NA error in Array formula | Excel Discussion (Misc queries) | |||
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) |