| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum x number of right cells after finding first cell more than 0.
If the formula was placed in the position shown
in the example, wouldn't you get a circular reference? If the string of zeros extended into the last 12 cells of your data and there was unrelated data following your data, would you not get a wrong answer? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
