Thread: summing arrays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ray S. Ray S. is offline
external usenet poster
 
Posts: 40
Default summing arrays

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?