Rogier van Vlissingen wrote:
I tried it out like this, but it does not work it gives me a #VALUE!
error.
On Mon, 12 Jan 2009 21:31:09 -0500, TomW <[email protected]> wrote:
=AVERAGE(IF(ConsBillPeriods>=FromPeriod;(IF(ConsBillPeriods<=ToPeriod;M16:T16))))
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.9/1902 - Release Date: 1/19/2009 9:37 AM
Rogier:
I neglected to mention that array formulas use "ctrl shift" with "enter"
in order to work. Using just "enter" will give the "Value ! error.
Bad me!
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
