Originally Posted by 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" 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