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?

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

Post what you have tried

--
Don Guillett
SalesAid Software

"curtll" wrote in message
...

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

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

=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" wrote in message
...

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

"curtll" wrote in message
...

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

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.

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?

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" wrote in message
...

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" wrote in message
...

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

"curtll" wrote in message
...

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