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...
--
Rogier van Vlissingen
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
