averageif function

[curtll]

Hello, Im trying to have information from C2:C3 averaged unless C2 is
blank or 0. If it is 0 or blank I want B3 to be blank. I am trying to
add this formula into B3. Ive tried a lot of different formulas and
nothing is working. Can anyone help?


--
curtll

[Elkar]

Try this:

=IF(OR(C2={0,""}),"",AVERAGE(C2:C3))

HTH,
Elkar

"curtll" wrote:

>
> Hello, Im trying to have information from C2:C3 averaged unless C2 is
> blank or 0. If it is 0 or blank I want B3 to be blank. I am trying to
> add this formula into B3. Ive tried a lot of different formulas and
> nothing is working. Can anyone help?
>
>
> --
> curtll
>

[Don Guillett]

Post what you have tried

--
Don Guillett
SalesAid Software
[email protected]
"curtll" <[email protected]> wrote in message
news:[email protected]...
>
> Hello, Im trying to have information from C2:C3 averaged unless C2 is
> blank or 0. If it is 0 or blank I want B3 to be blank. I am trying to
> add this formula into B3. Ive tried a lot of different formulas and
> nothing is working. Can anyone help?
>
>
> --
> curtll

[curtll]

Ive tried {=AVERAGE(IF(C2=0,0,C2:C3))} and several different variations
of it.

Don Guillett Wrote:
> Post what you have tried
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "curtll" [email protected] wrote in message
> news:[email protected]...
>
> Hello, Im trying to have information from C2:C3 averaged unless C2 is
> blank or 0. If it is 0 or blank I want B3 to be blank. I am trying
> to
> add this formula into B3. Ive tried a lot of different formulas and
> nothing is working. Can anyone help?
>
>
> --
> curtll


--
curtll

[Peo Sjoblom]

=IF(C2=0,"",AVERAGE(C2:C30))

--

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


"curtll" <[email protected]> wrote in message
news:[email protected]...
>
> Ive tried {=AVERAGE(IF(C2=0,0,C2:C3))} and several different variations
> of it.
>
> Don Guillett Wrote:
>> Post what you have tried
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "curtll" [email protected] wrote in message
>> news:[email protected]...
>>
>> Hello, Im trying to have information from C2:C3 averaged unless C2 is
>> blank or 0. If it is 0 or blank I want B3 to be blank. I am trying
>> to
>> add this formula into B3. Ive tried a lot of different formulas and
>> nothing is working. Can anyone help?
>>
>>
>> --
>> curtll
>
>
> --
> curtll

[curtll]

Yea neither of those are working. There is one more thing I want to
add. When we come to the next day(b4) even if there is a blank on the
previous day I need it to keep the figure from the previous average.
Basically I need to have the cells below the current and future days
kept blank until the daily average is inputed in column c. I know i
shouldve said this from the beginning but didnt realize it.


Peo Sjoblom Wrote:
> =IF(C2=0,"",AVERAGE(C2:C30))
>
> --
>
> 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
>
>
> "curtll" [email protected] wrote in message
> news:[email protected]...
>
> Ive tried {=AVERAGE(IF(C2=0,0,C2:C3))} and several different
> variations
> of it.
>
> Don Guillett Wrote:
> Post what you have tried
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "curtll" [email protected] wrote in message
> news:[email protected]...
>
> Hello, Im trying to have information from C2:C3 averaged unless C2 is
> blank or 0. If it is 0 or blank I want B3 to be blank. I am trying
> to
> add this formula into B3. Ive tried a lot of different formulas and
> nothing is working. Can anyone help?
>
>
> --
> curtll
>
>
> --
> curtll


--
curtll

[Ragdyer]

You're sending mixed messages!

First you say to carry the previous average down if the present row is
empty:
<<"When we come to the next day(b4) even if there is a blank on the previous
day I need it to keep the figure from the previous average.">>

THEN you say you want the column to be empty if there's no data in the row:
<<"Basically I need to have the cells below the current and future days kept
blank until the daily average is inputed in column c.">>

So, which is it ? ? ?

Also, are you averaging *only* 2 cells (days) at a time, or ... is the
average to include *all* of Column C to date?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"curtll" <[email protected]> wrote in message
news:[email protected]...
>
> Yea neither of those are working. There is one more thing I want to
> add. When we come to the next day(b4) even if there is a blank on the
> previous day I need it to keep the figure from the previous average.
> Basically I need to have the cells below the current and future days
> kept blank until the daily average is inputed in column c. I know i
> shouldve said this from the beginning but didnt realize it.
>
>
> Peo Sjoblom Wrote:
> > =IF(C2=0,"",AVERAGE(C2:C30))
> >
> > --
> >
> > 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
> >
> >
> > "curtll" [email protected] wrote in message
> > news:[email protected]...
> >
> > Ive tried {=AVERAGE(IF(C2=0,0,C2:C3))} and several different
> > variations
> > of it.
> >
> > Don Guillett Wrote:
> > Post what you have tried
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "curtll" [email protected] wrote in message
> > news:[email protected]...
> >
> > Hello, Im trying to have information from C2:C3 averaged unless C2 is
> > blank or 0. If it is 0 or blank I want B3 to be blank. I am trying
> > to
> > add this formula into B3. Ive tried a lot of different formulas and
> > nothing is working. Can anyone help?
> >
> >
> > --
> > curtll
> >
> >
> > --
> > curtll
>
>
> --
> curtll

[curtll]

Nevermind I figured it out. Now how do I take an average from 1 cell on
several sheets, w/o including 0's or blank cells and get it to average
correctly?

curtll Wrote:
> Yea neither of those are working. There is one more thing I want to
> add. When we come to the next day(b4) even if there is a blank on the
> previous day I need it to keep the figure from the previous average.
> Basically I need to have the cells below the current and future days
> kept blank until the daily average is inputed in column c. I know i
> shouldve said this from the beginning but didnt realize it.


--
curtll

[curtll]

Im sorry, thats probably my issue with this im over analyzing
it.....anyways I figured how to get column b to only populate with the
corresponding date in column a except that when there is no numbers in
column c its still populating #div/0 in column b....kind of annoyed
with that right now so im not to worried about that right now although
it would be nice to know how to add that into the forumla: this is in
cell b3 =IF(NOW()<=A4,"",AVERAGE(C2:C4)).....the more important one
would be to just average 1 cell over several worksheets, but not
include the #div/0 or blank cells. Ive tried a lot of different ones
and have done a lot of research and nothing is working. Any help would
be awesome!

Ragdyer Wrote:
> You're sending mixed messages!
>
> First you say to carry the previous average down if the present row is
> empty:
> "When we come to the next day(b4) even if there is a blank on the
> previous
> day I need it to keep the figure from the previous average."
>
> THEN you say you want the column to be empty if there's no data in the
> row:
> "Basically I need to have the cells below the current and future days
> kept
> blank until the daily average is inputed in column c."
>
> So, which is it ? ? ?
>
> Also, are you averaging *only* 2 cells (days) at a time, or ... is the
> average to include *all* of Column C to date?
>
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit
> !
> ---------------------------------------------------------------------------
> "curtll" [email protected] wrote in message
> news:[email protected]...
>
> Yea neither of those are working. There is one more thing I want to
> add. When we come to the next day(b4) even if there is a blank on
> the
> previous day I need it to keep the figure from the previous average.
> Basically I need to have the cells below the current and future days
> kept blank until the daily average is inputed in column c. I know i
> shouldve said this from the beginning but didnt realize it.
>
>
> Peo Sjoblom Wrote:
> =IF(C2=0,"",AVERAGE(C2:C30))
>
> --
>
> 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
>
>
> "curtll" [email protected] wrote in message
> news:[email protected]...
>
> Ive tried {=AVERAGE(IF(C2=0,0,C2:C3))} and several different
> variations
> of it.
>
> Don Guillett Wrote:
> Post what you have tried
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "curtll" [email protected] wrote in message
> news:[email protected]...
>
> Hello, Im trying to have information from C2:C3 averaged unless C2
> is
> blank or 0. If it is 0 or blank I want B3 to be blank. I am trying
> to
> add this formula into B3. Ive tried a lot of different formulas and
> nothing is working. Can anyone help?
>
>
> --
> curtll
>
>
> --
> curtll
>
>
> --
> curtll


--
curtll