Thread: countif
View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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))