help with AVERAGE problem

[Dwise85]

Hi,

I am trying to find the average in a column. If there is not data in that column I went to reference the data in another cell and use that as "the average" for that column. Any help would be greatly appreciated!

for example:
column 1 cells A1:A8 are averaged in A9, column 2 cells B1:B8 are averegd in B9, column C cells C1:C8 are averaged in C9 but all cells are blank and returing a #div/0!. if this is the case I want to use the data that is in E6 and and use that as the average if this is the case.

 

[Dwise85]

 

[Dwise85]

 

[Dwise85]

Hi,

I want to use the data that is in E6 and and use that as the average if this is the case.

sorry I want to use the data in h6 not e6 hopes the pic helps

 

[jtakw]

Hi,

You can just wrap your formula with IFERROR:

=IFERROR(AVERAGEIF(D2:D8,"<>0"),H6)

 

[Eric W]

Welcome to the forum.

How about:

=IFERROR(AVERAGE(D2:D8),$H$6)

AVERAGEIF may not be required, since AVERAGE ignores empty cells.

 

[Dwise85]

Awsome guys thanks heaps!

 

[jtakw]

You're welcome, welcome to the forum.

 

[Michael M]

So simply

=AVERAGE(B2:B8)