| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
row reference
I want to take the average of every other row in my data set and I will be
adding weeks to the data as time moves forward. Is there a relative or absolute formula that does this? Thanks for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
row reference
Similar to columns, but pre-2007 can handle entire column callouts.
Odd rows: =AVERAGE(IF(MOD(ROW(A1:A100),2)*ISNUMBER(A1:A100), A1:A100)) Even rows: =AVERAGE(IF((MOD(ROW(A1:A100),2)=0)*ISNUMBER(A1:A1 00),A1:A100)) Both are array formulas, must be confirmed using Ctrl+Shift+Enter, not just Enter. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mike" wrote: I want to take the average of every other row in my data set and I will be adding weeks to the data as time moves forward. Is there a relative or absolute formula that does this? Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
Hybrid Mode
