| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the current row in a formula
This is probably a simple question :)
I have a formula where I would like to reference a different column in whatever row the formula is in. Something along the lines of =SUM( A:ROW()...C:ROW() ) which would sum up column A to column C for whatever row youre currently in. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the current row in a formula
=SUM(OFFSET(A1,0,0,ROW(),3))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ups.com... This is probably a simple question :) I have a formula where I would like to reference a different column in whatever row the formula is in. Something along the lines of =SUM( A:ROW()...C:ROW() ) which would sum up column A to column C for whatever row youre currently in. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the current row in a formula
This appeared to work (in extremely limited testing) :
=SUM(INDEX(A:A,ROW()):INDEX(C:C,ROW())) -- Kevin Vaughn " wrote: This is probably a simple question :) I have a formula where I would like to reference a different column in whatever row the formula is in. Something along the lines of =SUM( A:ROW()...C:ROW() ) which would sum up column A to column C for whatever row youre currently in. Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the current row in a formula
Excuse me Kevin n Bob....Mr. tinyg - please be specific ..Do you want to sum
the values of all cells within Columns A to C, or sum a range that are from row 1 to row() , column A to C ? "Kevin Vaughn" wrote: This appeared to work (in extremely limited testing) : =SUM(INDEX(A:A,ROW()):INDEX(C:C,ROW())) -- Kevin Vaughn " wrote: This is probably a simple question :) I have a formula where I would like to reference a different column in whatever row the formula is in. Something along the lines of =SUM( A:ROW()...C:ROW() ) which would sum up column A to column C for whatever row youre currently in. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| including current date in formula | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| formula IF returning current date | Excel Worksheet Functions | |||
Linear Mode
