Average SUMof mutilple cells

[speakez]

ok i have a dilemma, im pretty new to excel and havent been able to find
the solution anywhere on google.

in cells C14,E14,G14,I14,K14,M14 i have SUM functions, I want to
average the results of the SUM functions in another cell, however i
wish to skip over the cells that have zeros.

how can i do this?

any help is appreciated.

Thank You

 

[Gary''s Student]

AVERAGE() will automatically exclude blanks, but not zeros, so lets make
zeros into blanks:



Suppose that C14 has something like A1+B1 as the formula. Instead of:
=A1+B1
use
=if(A1+B1=0,"",A1+B1)

Now C14 will be blank rather than zero, and the AVERAGE() won't include it.

 

[speakez]

awesome, that works perfectly. Thank You