Array calculations in different directions

[Insomniac53]

I have a 2D array, 'Sales Record'!B$2:B$42 up to M$2-M$42, and a one dimensional vertical array, Totals, in another worksheet, which must sum each column of SalesRecord in turn then move down to the next cell and repeat the calculation for the next column in the SalesRecord array. So, the first calculation (cell C3 in Totals) will sum all the values from SalesRecord B2toB42; the next calculation (in Totals cell C4) will sum the table column from C2 to C42; the thiird calculation (in cell C5) will sum the values from D2 to D42 and so on. This is probably basic Excel but I'm not sure the simplest way to do it. Can anyone advise? Thanks

[shg]

In C3 and copy down,

=SUM(INDEX('Sales Record'!B$2:M$42, 0, ROWS(C$3:C3)))

[ConneXionLost]

Give this a try:

Please Login or Register  to view this content.

Cheers,

[Insomniac53]

Many thanks! I will try this and reply later. Much appreciated.