ExcelBanter - AVERAGE NUMBER IN COLUMN PROBLEM

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - AVERAGE NUMBER IN COLUMN PROBLEM (https://www.excelbanter.com/excel-worksheet-functions/145351-average-number-column-problem.html)

roy.okinawa

AVERAGE NUMBER IN COLUMN PROBLEM

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.

JE McGimpsey

AVERAGE NUMBER IN COLUMN PROBLEM

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.

In article ,
roy.okinawa wrote:

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.

All times are GMT +1. The time now is 10:46 PM.