Try this...

=(SUMIF(R6:V6,"<=5")+SUMIF(X6:Z6,"<=5")+(P6<=5)*P6 )/INDEX(FREQUENCY((P6,R6:V6,X6:Z6),5),1)



--
Biff
Microsoft Excel MVP


"Daniel Collison" wrote:

I am trying to average a range of numbers if the values are less than or
equal to 5. The range includes non-consecutive cells. I have attempted two
different versions of the averageif formula (see below). Both versions
return a #VALUE error.

=AVERAGEIF((P6,R6,S6,T6,U6,V6,X6,Y6,Z6),"<=5")
=AVERAGEIF((P6,R6:V6,X6:Z6),"<=5")

Thanks,