Posted to microsoft.public.excel.programming

More Macro Help Needed More Macro Help Needed is offline

external usenet poster

Posts: 4

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Array Formulas to Regular Formulas	Domenick	Excel Worksheet Functions	6	August 17th 15 09:16 PM
Convert Array Formulas to Regular Formulas	minyeh	Excel Worksheet Functions	0	March 21st 10 05:55 AM
array formulas	Ray S.	Excel Discussion (Misc queries)	0	August 8th 08 08:15 PM
3d array formulas	Idoia	Excel Discussion (Misc queries)	2	June 19th 08 04:30 PM
Formulas with-an an array	Dave	Excel Worksheet Functions	2	December 12th 07 03:24 PM

All times are GMT +1. The time now is 01:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us