Formula find percentage greater than 3

I have to create an FCAT worksheet and would like to be able to average the total number of scores equal to or greater that 3. Numerical input is 1-5.
Thanks

There is probably a cleaner way to accomplish this, but here is an option.

You could use a hidden helper column that contains this formula (if the values are in column A, this could be in column B)

=IF(A1>=3,A1,"")

then in column C you could use something like this:

=AVERAGE(B:B)

Originally Posted by jkubec

I have to create an FCAT worksheet and would like to be able to average the total number of scores equal to or greater that 3. Numerical input is 1-5.
Thanks

Following formula should to the trick

=average(if(your_range>2,your_range,false))

This formula should be eneterd as an array with Ctrl+Shift+Enter

(I suppose you have no decimal numbers in your range