averageif function

C

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?
 
P

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
 
C

curtll

Yea neither of those are working. There is one more thing I want t
add. When we come to the next day(b4) even if there is a blank on th
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 day
kept blank until the daily average is inputed in column c. I know
shouldve said this from the beginning but didnt realize it.
 
R

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?
 
C

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?
 
C

curtll

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