Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum offset question
I need to sum a range based on the number on another cell
I use the following function to get that =SUM(OFFSET(J45,0,0,L12)) (basically summing J45 thru J49 since cell L12 contains value 5) I gives me the correct result from above formula when summing across rows. However when I change that formula to sum across columns and changing the same formula to =SUM(OFFSET(J45,0,0,0,L12)) to sum across columns it gives me a result #REF! What would be the correct formula to sum across columns. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
basic pie chart question | Charts and Charting in Excel | |||
OFFSET and array formulae | Excel Discussion (Misc queries) | |||
Offset? | Excel Discussion (Misc queries) | |||
Have a question on scrolling sum with Excel. | Excel Worksheet Functions | |||
end of worksheet question | Excel Worksheet Functions |