Block summing

  • Thread starter Thread starter Gnasher
  • Start date Start date
G

Gnasher

Subject: Row sum
From: Gnasher
<john<underscore>yeadon<underscore>athome@blueyonder<dot>co<dot>uk>

Given a large squareish named block of numeric data called say
'SquareBlock', is it possible to sum the rows (or columns) individually
with a single {block formula}.

{=SUM(SquareBlock)}

Adds all the cells in the block and repeats the answer in the row/column
and hence is not what I want.

An index column with values 1..60 is already in a column at the side of
the block. Can this be used somehow to obtain what I want?

Otherwise I shall just have to stick to summing rows/columns with the
usual: =SUM(from:to)
 
I'm not sure I totally understand what you want, but the only way I know to
accumulate sums of various rows/columns into one formula without summing the
whole, would be to Concatenate them........like.......

=SUM(C12:C16)&" "&SUM(D12:D16)&" "&SUM(E12:E16)

hth
Vaya con Dios,
Chuck, CABGx3
 
Look at INDEX,

to sum the first column in SquareBlock

=SUM(INDEX(SquareBlock,,1))

to sum the third row

=SUM(INDEX(SquareBlock,3,))



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Cheers Peo: {=SUM(INDEX(DataBlock,Row_No,))} will sum rows using names &
array formulas but avoiding cell references, just like I wanted. Ta!
 
Back
Top