Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a sum from a given number of rows
Hello,
I'm looking for a formula that can calculate the sum of a number of rows given. In the example below the formula should output the sum of the figures from the last 7 rows (starting from the right to the left). --------------------------------------------- Rows (from right to left) A1: 7 A B C D E F G H I J K 4 5 3 2 8 9 5 6 3 2 4 Output: sum rows E-K --------------------------------------------- I used to calculate this using a IF formula, however that only worked until i reached the maximum of 6 IF brackets "()". Does anybody has an idea? Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating rows | New Users to Excel | |||
Calculating volume and number. | Excel Worksheet Functions | |||
Inserted Rows not re-calculating | Excel Discussion (Misc queries) | |||
Text number to number value for calculating | Excel Worksheet Functions | |||
deleting rows--calculating formulas with each row as it goes? | Excel Discussion (Misc queries) |