Thanks for the clarification. Yes, I originally entered instead of
Control/Shift and enter.

Now I'm getting #Div/0, and what's weird about that is, I put in a value at
every cell to test.

I'm baffled. Any other insight you could give would be much appreciated.

Thanks!

"JE McGimpsey" wrote:

It's probably because you didn't hold down CTRL and SHIFT when you hit
ENTER.

Since your first column is the 14th ("N"), MOD(COLUMN(N),10) = 4.
Subsequent columns also have this property since you're averaging every
10th column,.



In article ,
Renee - California wrote:

I've plugged this in and I'm getting #Value! return. Any ideas on why?
Also, what does the =4 signify is this formula?

Thanks again for your help.

"JE McGimpsey" wrote:

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF((MOD(COLUMN(N13:IJ13),10)=4)*(N13:IJ13 0),N13:IJ13))