| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increment cell reference in a formula
Hi All,
I am using a DAVERAGE formula and need to increment the criteria reference when I use the fill command. my formula is =DAVERAGE('Rhizome Counts I'!$B$3:$I$6,"RhizKG2",B4:B5) I want to be able to Fill Down this formula and increment B4:B5 by 2 each time i.e. B6:B7 B8:B9 B10:B11 etc i Have tried the Serires option on the fill function but this didnt work. Any suggestions. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - How to increment cell reference by one row | Excel Worksheet Functions | |||
| Need formula to increment cell reference every 8th row | Excel Discussion (Misc queries) | |||
| Increment cell reference | Excel Discussion (Misc queries) | |||
| how to make cell address reference increment? | Excel Worksheet Functions | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Threaded Mode
