Array calculations in opposite directions

[MuddyBrain3]

I have a 2D array (a table?) 'Sales Record'!B$2:B$42 up to M$2-M$42) and a one dimensional vertical array (called 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 a 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. You get the drift. This is probably basic Excel but I'm not sure the simplest way to do it. Can anyone advise?
Thanks

 

[Aladin Akyurek]

Try...

C3, copy down:

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

 

[MuddyBrain3]

Thank You! That seems to work fine! I have no idea how it works but I'll study it over the next couple of days and learn. Much appreciated.