Hello,
I need a formula to calculate the average of a column excluding blanks and any number greater than 10.
Thank You
I used
but I am lost when trying to write a formula to exclude blanks an only average the columns containing 1-10 only excluding the average of any number greater than 10.
I need a formula to calculate the average of a column excluding blanks and any number greater than 10.
Thank You
I used
Code:
=SUBTOTAL(101,A3:A109)