=IF(COUNT(OFFSET($B18,-4,0,-6,1))=6,IF(NOT(ISERROR(AVERAGE(OFFSET(C18,-4,0,-
6,1)))),AVERAGE(OFFSET(C18,-4,0,-6,1)),NA()),NA())

--
HTH

Bob Phillips

"StephanieH" wrote in message
...
Is it possible to add one more argument to this formula?


=IF(COUNT(OFFSET($B138,-4,0,-6,1))=6,AVERAGE(OFFSET(C138,-4,0,-6,1)),"N/A")

I want to specify that if the result of the average is an error, then also
return "N/A"