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!
Quote:
|
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 |