I agree, it would be useful to have a minimum cell count as function of the AVERAGEIFS formula. I'm currently looking at the number of records in the table below the AFR Averages table to determine data validity.

The basic near idle formula I started with:
AVERAGEIFS('Insert Datalog'!,'Insert Datalog'!,"=Closed",'Insert Datalog'!,"=On",'Insert Datalog'!,"=Inactive",'Insert Datalog'!,"=Inactive",'Insert Datalog'!,">=XX",'Insert Datalog'!,"<=YY",'Insert Datalog'!,">=XXX",'Insert Datalog'!,"<YYYY")

dave w