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