| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Quote:
Column B has all the dates Column C has all the data Cell A1 has the start date to be averaged Cell A2 has the end date to be averaged =AVERAGE(OFFSET(C1,MATCH(A1,B:B,0)-1,0,(A2-A1)+1,1)) If you want it just plain 30 days from the start date: =AVERAGE(OFFSET(C1,MATCH(A1,B:B,0)-1,0,30,1))
__________________
Asobi Wa Owari Da |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I increase a cell reference in VLOOKUP by 11 when copying? | Excel Discussion (Misc queries) | |||
| Increase Cell reference by 1 for every step | Excel Discussion (Misc queries) | |||
| How to Create Macro to Increase Cell Value to one and Print Worksheet | Excel Worksheet Functions | |||
| HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO. | Excel Discussion (Misc queries) | |||
| increase a cell reference by increments greater than one... | Excel Worksheet Functions | |||
Threaded Mode
