| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formulas
I need to be able to put an array formula in a cell and fill it across. The
formula needs to have a variable in it. This is what I have so far but it doesn't like it: =Average(IF(B5:Bx$H$2, IF(B5:Bx<$I$2, B5:Bx,""),"")) where "x" is the variable. Any ideas?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array Formulas
Hi
try: =Average(IF(INDIRECT("B5:B" & x)$H$2, IF(INDIRECT("B5:B" & x)<$I$2, INDIRECT("B5:B"&x),""),"")) -- Regards Frank Kabel Frankfurt, Germany "More Macro Help Needed" schrieb im Newsbeitrag ... I need to be able to put an array formula in a cell and fill it across. The formula needs to have a variable in it. This is what I have so far but it doesn't like it: =Average(IF(B5:Bx$H$2, IF(B5:Bx<$I$2, B5:Bx,""),"")) where "x" is the variable. Any ideas?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| array formulas | Excel Discussion (Misc queries) | |||
| 3d array formulas | Excel Discussion (Misc queries) | |||
| Formulas with-an an array | Excel Worksheet Functions | |||
Linear Mode
