| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Column above current cell dynamically using function call
I want to sum the column above current cell using the formula
=SUM(C3:activecell's row - 1) My question is how do I determine the row number above the current cell. I know CELL("row") returns the current row but could not find a way of using this in the formula. I know there are ways round this eg. SUM(C3:Cn) where n is manually entered but I want to know of a way to do it using an Excel function. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I call current computer time to a cell? | Excel Worksheet Functions | |||
| Use reference text from one cell in another function call | Excel Worksheet Functions | |||
| How do i call a function to a cell? | Excel Worksheet Functions | |||
| Can I get current #row or #column in cell formula? | Excel Discussion (Misc queries) | |||
| Get current cell with VBA function | Excel Worksheet Functions | |||
Threaded Mode
