Great, better and better all the time!!!
On Mon, 12 Jan 2009 21:31:09 -0500, TomW <[email protected]> wrote:
Rogier van Vlissingen wrote:
This is what I'm trying to do:
=AVERAGE( HLookup(X14, ConsBillArray, 11) : HLookup(x15, ConsBillArray,
11) )
and in this form it returns an error.
What happens is, the HLookups produce a number, not a cell reference,
and therefore AVERAGE is now looking for a list of numers, separated by
commas, and I can't use the array specification.
Somehow I can't figure out how to do it, even though I can figure out
why it does not work this way...
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database:
270.10.5/1881 - Release Date: 1/7/2009 5:59 PM
Rogier:
An example using array formulas:
{=AVERAGE(IF(ConsBillPeriods>=FromPeriod;(IF(ConsBillPeriods<=ToPeriod;M16:T16))))}
It my view it is more readable as to what it does. One could also use:
{=AVERAGE(IF(ConsBillPeriods>=FromPeriod;(IF(ConsBillPeriods<=ToPeriod;ETax))))}
Where "ETax" is a name range for M16:T16.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
Rogier van Vlissingen
www.acimnthomas.com
www.xanga.com/RogierFvV
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
