Here's the challenge I am having. I have a SUM array formula in one cell. One of the data elements I am trying to sum up in the array cell is pulling from another cell that has a SUM formula already in it. That second cell with the formula is not an array. I am unable to successfully pull that data from the second cell to my first SUM arrany cell.

What I did was to have the value in the second cell pull to a third cell using a simple copy formula =E5 However, the SUM array on the first cell wouldn't work with this scenario either.

How can I get my SUM array to recognize either cells so that my calculation can be pulled?

Thank you