need 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


"MrJim005" <[email protected]> wrote in message
news:[email protected]...
>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
>
>

[CLR]

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

Vaya con Dios,
Chuck, CABGx3


"MrJim005" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[Ragdyer]

=Average(A1:A31)

The Average() function ignores blank cells.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"MrJim005" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[Dave Peterson]

I think you dropped an =if(

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

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

Peo Sjoblom wrote:
>
> 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
>
> "MrJim005" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
> >

--

Dave Peterson