need to ignore blank values in AVERAGEA formula

Good morning,

The project Im working on is looking at a set of values to see if they are in between a min and max value. To find this I am using this formula

=IF(C9="","",AND(C9>MIN(C$3,E$3),C9<MAX(C$3,E$3)))

From these true/false values, we are trying to find the average of this, which i am using an AVERAGEA formula

=AVERAGEA(D9:D1009)

However, we are wanting a 'real time' adjustment to the average as we enter the values to see if they are in between or not. How do I adjust the AVERAGEA formula to ignore the blank values in column D

thank you!

Instead of AVERAGEA. try using multiple count formulas instead.
This Counts the number of "TRUE" and divides it by the total number of non blank cells in the range.

Formula:

Please Login or Register  to view this content.

@dosydos I am getting the same result. I am wondering if because the cell isnt truly blank? It has a formula in it, but it just shows up as blank until we put a value in there?

whoops your right sorry, try this out instead:

Formula:

Please Login or Register  to view this content.