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))))
-- Rogier van Vlissingen www.acimnthomas.com www.xanga.com/RogierFvV --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
