AVERAGE NUMBER IN COLUMN PROBLEM

R

roy.okinawa

I am using this formula =AVERAGE(IF(K8:K964<>0, K8:K964,"")) to average all
the numbers in a column. It has been working fine until the other day. Now
all I get is #VALUE.

What could be the problem?

Thanks.
 
J

JE McGimpsey

What could be the problem?

Couple ideas:

A) you edited the formula and didn't array-enter it (using
CTRL-SHIFT-ENTER or CMD-RETURN)

B) One of the K8:K964 cells contains the #VALUE! error.
 
Top