Bless your heart, I should have remembered that, but did not...
This is great!!!
On Mon, 19 Jan 2009 19:33:12 -0500, TomW <[email protected]> wrote:
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]
--
Rogier van Vlissingen
www.acimnthomas.com
www.xanga.com/RogierFvV
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
