Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I am finding a solution (formula) to automatically sum (3 or 12) cells on the right after encountering first right cell greater than 0. Currently, this is done manually. (eg. 3.9 is the sum of 2.9 (Aug) + 0.5 (Sep) + 0.4 (Oct).) Question is there a way to do this automatically because there are thousands of rows..and this will drive me crasy in maintaining this worksheet effectively. Thanks. First First 3M 12M Jul Aug Sep Oct Nov Dec .................... ------------------------------------------------------------------------------------------------------------------------------------------- 3.9 5.4 0.0 2.9 0.5 0.4 0.3 0.2 .................... 1.0 2.2 0.0 0.9 0.0 0.2 0.0 0.4 .................... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 .................... 3.2 5.2 0.0 0.0 0.0 1.9 1.3 0.9 .................... 3.1 5.1 0.0 0.0 0.0 0.5 1.7 0.9 .................... 2.6 3.9 0.0 0.0 0.0 0.4 1.1 1.1 .................... ........................ ........................ Ivan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
finding the maximum number of used cells in any column of a table | Excel Worksheet Functions | |||
Finding the Row number based on contents of a cell | Excel Worksheet Functions | |||
Finding Number of cells in a column of other sheet having a specific word in them | New Users to Excel | |||
Finding cells with a specific number of characters | Excel Discussion (Misc queries) | |||
finding a particular cell in another worksheet whose row number ch | Excel Discussion (Misc queries) |