| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Guy's solution is better than mine...
I made a minor change to it: =SUM(OFFSET($U$2,$B3,-$A2+1,1,$A$2)) $U$2 = Jan $B3 = x value $A2 = # of months Quote:
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Threaded Mode
