Average Formula

[MrJim005]

I need a formula that averages A1 through A31 and need to ignore blank cells
in that range that contain formulas that reference data from other sheets. I
need it only to average them once they populate with data. Thank you if this
is possible.



Thank You

 

[Peo Sjoblom]

Average ignore blank cells, if the linked formulas return zero when empty
change the formula to

=other_sheet_cell="","",formula_with_other_sheet_cell))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[CLR]

=SUM(A1:A31)/COUNT(A1:A31)

Vaya con Dios,
Chuck, CABGx3

 

[Ragdyer]

=Average(A1:A31)

The Average() function ignores blank cells.

 

[Dave Peterson]

I think you dropped an =if(

=if(other_sheet_cell="","",formula_with_other_sheet_cell)

Like:
=if(sheet1!a1="","",sheet1!a1)