Thanks Domenic -

This returned a Div/0 result. Any Ideas???

I appreciate your time and efforts!!

"Domenic" wrote:

Try...

=AVERAGE(IF((MOD(COLUMN(N13:IJ13)-COLUMN(N13),10)=0)*(N13:IJ130),N13:IJ1
3))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
Renee - California wrote:

I need to average this range assuming all cells have a value 0. What's the
correct function to
use???(N13+X13+AH13+AR13+BB13+BL13+BV13+CF13+CP13+ CZ13+DJ13+DT13+ED13+EN13+EX1
3+FH13+FR13+GB13+GL13+GV13+HF13+HP13+HZ13+IJ13)