How to appy the formular with different cell parameters~kindly hel
 

I am working on a worksheet which require me to do this:
For cell A80, it is equal to Sum of A1 to A10
For cell A81, it is equal to Sum of A11 to A20
For cell A82, it is equal to Sum of A21 to A30
and so on......

Is there a easy way to do it instead of mannually change the formular one by
one?????
--
Learn More!

How to appy the formular with different cell parameters~kindly hel
 

=SUM(INDIRECT("a"&INT(ROW()/8)-9+MOD(ROW(),8)&":A"&INT(ROW()/8)+MOD(ROW(),8)))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JL" wrote in message
...
I am working on a worksheet which require me to do this:
For cell A80, it is equal to Sum of A1 to A10
For cell A81, it is equal to Sum of A11 to A20
For cell A82, it is equal to Sum of A21 to A30
and so on......

Is there a easy way to do it instead of mannually change the formular one
by
one?????
--
Learn More!

How to appy the formular with different cell parameters~kindly hel
 

"JL" wrote:
I am working on a worksheet which require me to do this:
For cell A80, it is equal to Sum of A1 to A10
For cell A81, it is equal to Sum of A11 to A20
For cell A82, it is equal to Sum of A21 to A30
and so on......
Is there a easy way to do it instead of mannually change
the formular one by one?????

Put the following into A80 and copy down:

=SUM(OFFSET($A$1:$A$10,10*(ROW()-ROW($A$80)),0))