summing many arrays

  • Thread starter Thread starter Jamie Martin
  • Start date Start date
J

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)1:(A:Y)100)?

Thanks,

Jamie
 
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
 
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
 
Back
Top