Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup doesn't work consistently (I think), kindly help | Excel Worksheet Functions | |||
How to appy range names to formulas which use single cells in rang | Excel Discussion (Misc queries) | |||
How to appy range names to formulas which use single cells in rang | Excel Worksheet Functions | |||
kindly help me w/mail merge in xcel;40recipients1 text | Excel Discussion (Misc queries) | |||
Cell formular | Excel Discussion (Misc queries) |