Array Formulas

[Guest]

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

 

[Frank Kabel]

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" <[email protected]>
schrieb im Newsbeitrag
news:[email protected]...