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]
