=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