Graphing an Average Formula that returns a zero answer

i am attempting to graph a series of answers returned by the formula below – i want the graph to ignore any zeros returned by the formula. i’ve set the chart to ignore zeros i’ve tried substituting NA() for “”. so far no luck. i’m sure there is a more elegant way to write the formula, but i don’t know it. btw, not all of the cells being averaged contain values. formula is: =IF(COUNT(B3,B27,B51,B74,B98,B121,B144)=0,””,((+B3+B27+B51+B74+B98+B121+B144)/(COUNT(B3,B27,B51,B74,B98,B121,B144))))
thanks,
Sherri