SumProduct Statement

Please take a look at the highlighted cell on the 'Atlanta' Tab - how can i set up my formula to ignore 'zero' values when calculating the average? Can i do an averageif statement in front of the sum product statement?

Thanks for the helpAtlanta RSA Survey Trends 130218.xlsx

Thanks, but I don't see how the link you posted covers averages across multiple tabs - can you add the formula to the file I attached so I can see how it works?