R
Ray S.
Is it possible to sum two arrays? I have a large array with specific total
amounts for each item in each column and row of the array. Along column A
there are 40 rows of specific finance items. Columns B through X identify
specific business entities. The points at which the rows and columns cross
contain dollar amounts. I have two such large files and I want to essentially
combine them. They both have the same 40 items and the same business
entities, but with different dollar amounts. Is there a formula or function
whereby I can add the two together?
amounts for each item in each column and row of the array. Along column A
there are 40 rows of specific finance items. Columns B through X identify
specific business entities. The points at which the rows and columns cross
contain dollar amounts. I have two such large files and I want to essentially
combine them. They both have the same 40 items and the same business
entities, but with different dollar amounts. Is there a formula or function
whereby I can add the two together?