Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing arrays
On Fri, 23 Jan 2009 12:24:00 -0800, Ray S.
wrote: 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? Is this to be done just once, or do you want to keep and update the two files with automatic update of the sum? In the first case you can select cells B2:X41 in the first sheet and do "Copy". Then select cell B2 in the second cell and do "Paste Special" with Operation set to "Add". In the second case you put the following formula in cell B2 of a new sheet: =Sheet1!B2+Sheet2!B2 where Sheet1 and Sheet2 are the names of you two sheets with data. Then copy this formula to the right thru cells C2:X2 Then copy cells B2:X2 down thru B3:X41 Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing arrays
Excel 2007
Consolidate two arrays. Arrays can be of different sizes, in any location, and with row/column items in any order. Output can be arranged, filtered and sorted multiple ways. All without formulas or code. All dynamically. http://www.mediafire.com/file/myonnobmliz/01_24_09.xlsx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing arrays
Wow! That solution is so cool that I think I'll go out and buy 2007. I'm
working with 2003. "Herbert Seidenberg" wrote: Excel 2007 Consolidate two arrays. Arrays can be of different sizes, in any location, and with row/column items in any order. Output can be arranged, filtered and sorted multiple ways. All without formulas or code. All dynamically. http://www.mediafire.com/file/myonnobmliz/01_24_09.xlsx |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing arrays
Your first case works fine for me...thanks.
"Lars-Ã…ke Aspelin" wrote: On Fri, 23 Jan 2009 12:24:00 -0800, Ray S. wrote: 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? Is this to be done just once, or do you want to keep and update the two files with automatic update of the sum? In the first case you can select cells B2:X41 in the first sheet and do "Copy". Then select cell B2 in the second cell and do "Paste Special" with Operation set to "Add". In the second case you put the following formula in cell B2 of a new sheet: =Sheet1!B2+Sheet2!B2 where Sheet1 and Sheet2 are the names of you two sheets with data. Then copy this formula to the right thru cells C2:X2 Then copy cells B2:X2 down thru B3:X41 Hope this helps / Lars-Ã…ke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help summing product of two arrays | Excel Discussion (Misc queries) | |||
PivotTable and summing/not summing | Excel Discussion (Misc queries) | |||
Use of arrays | Excel Worksheet Functions | |||
two arrays | New Users to Excel | |||
Summing Arrays | Excel Worksheet Functions |