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??

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??