I have a formula written in a column ten rows deep. Sometimes I use less
than 10 inputs. I'm trying to formulate an average of this column, but if I
don't input all 10 inputs, my average comes back with #DIV/0!

How can I get this column to average when some of the rows aren't being used?

Assuming data in A1:A10 In cell A11 use =average(A1:A10) The same applies if
data is in A1:A5 in cell A11 use the same formula. It will not consider blank
cells
HTH

"texanfanrocket" wrote:

I have a formula written in a column ten rows deep. Sometimes I use less
than 10 inputs. I'm trying to formulate an average of this column, but if I
don't input all 10 inputs, my average comes back with #DIV/0!

How can I get this column to average when some of the rows aren't being used?

I tried that. The problem might be that all of the 10 cells contain formulas
from different cells. When the inputs for those formulas are left out, it
gives the same #DIV/0! response.

While those responses don't mean anything, it is imperative that the cell
avg. is.

"Ray A" wrote:

Assuming data in A1:A10 In cell A11 use =average(A1:A10) The same applies if
data is in A1:A5 in cell A11 use the same formula. It will not consider blank
cells
HTH

"texanfanrocket" wrote:

I have a formula written in a column ten rows deep. Sometimes I use less
than 10 inputs. I'm trying to formulate an average of this column, but if I
don't input all 10 inputs, my average comes back with #DIV/0!

How can I get this column to average when some of the rows aren't being used?

Look at a combination of =if(iserror(
NOt clear without fooling with it how that will work but you can use the
iserror to filter out the #div/0

"texanfanrocket" wrote:

I tried that. The problem might be that all of the 10 cells contain formulas
from different cells. When the inputs for those formulas are left out, it
gives the same #DIV/0! response.

While those responses don't mean anything, it is imperative that the cell
avg. is.

"Ray A" wrote:

Assuming data in A1:A10 In cell A11 use =average(A1:A10) The same applies if
data is in A1:A5 in cell A11 use the same formula. It will not consider blank
cells
HTH

"texanfanrocket" wrote:

I have a formula written in a column ten rows deep. Sometimes I use less
than 10 inputs. I'm trying to formulate an average of this column, but if I
don't input all 10 inputs, my average comes back with #DIV/0!

How can I get this column to average when some of the rows aren't being used?

So try something like =IF(iserror #div/0!)AVERAGE(A1:A10)? That didn't work.
I'm not familiar with iserror inputs.

"Ray A" wrote:

Look at a combination of =if(iserror(
NOt clear without fooling with it how that will work but you can use the
iserror to filter out the #div/0

"texanfanrocket" wrote:

I tried that. The problem might be that all of the 10 cells contain formulas
from different cells. When the inputs for those formulas are left out, it
gives the same #DIV/0! response.

While those responses don't mean anything, it is imperative that the cell
avg. is.

"Ray A" wrote:

Assuming data in A1:A10 In cell A11 use =average(A1:A10) The same applies if
data is in A1:A5 in cell A11 use the same formula. It will not consider blank
cells
HTH

"texanfanrocket" wrote:

I have a formula written in a column ten rows deep. Sometimes I use less
than 10 inputs. I'm trying to formulate an average of this column, but if I
don't input all 10 inputs, my average comes back with #DIV/0!

How can I get this column to average when some of the rows aren't being used?

One way:

=IF(COUNTA1:A10),AVERAGE(A1:A10),"No inputs")

In article ,
"texanfanrocket" wrote:

I tried that. The problem might be that all of the 10 cells contain formulas
from different cells. When the inputs for those formulas are left out, it
gives the same #DIV/0! response.

While those responses don't mean anything, it is imperative that the cell
avg. is.

No, that just changed the answer to #NAME?

"JE McGimpsey" wrote:

One way:

=IF(COUNTA1:A10),AVERAGE(A1:A10),"No inputs")

In article ,
"texanfanrocket" wrote:

I tried that. The problem might be that all of the 10 cells contain formulas
from different cells. When the inputs for those formulas are left out, it
gives the same #DIV/0! response.

While those responses don't mean anything, it is imperative that the cell
avg. is.

Missed a paren:

=IF(COUNT(A1:A10),AVERAGE(A1:A10),"No inputs")

In article ,
"texanfanrocket" wrote:

No, that just changed the answer to #NAME?

"JE McGimpsey" wrote:

One way:

=IF(COUNTA1:A10),AVERAGE(A1:A10),"No inputs")

Try, array-entered (press CTRL+SHIFT+ENTER)
something like:

=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----