summing many arrays

[Jamie Martin]

I want Z1:Z100 to contain the sum of the values of
(A1:A100 + B1:B100 . . . + Y1:Y100).
Is there a way to specify this efficiently--something like
Z1:Z100 = SUM((A:Y)1A:Y)100)?

Thanks,

Jamie

 

[Arvi Laanemets]

Hi

???
What do you exactly want?

=SUM(A1:Y100) sums all values

Or you want to sum row-wise?
Enter into Z1 the formula
=SUM(A1:Y1)
and copy down (set cursor over lower-right corner of Z1, so the cursor
changes to black cross, left-click, and drag down)


Arvi Laanemets

 

[Paul Corrado]

Jamie,

If you highlight/select the entire range A1 to Z101 (one more row and one
more column than the data table) and use the Auto Sum Icon XL should insert
a total for each column and row and add a grand total in the lower right
corner.

PC

 

[Jamie Martin]

Great, that's awesome. Thank you.