Divide By Zero Error

[Dearster]

I'm trying to calculate the average percentage of a rolling 28 days and running year however when using SUM and COUNT it is coming up with a #Div/0! error and therefore not letting me calculate the rolling 28 day average or yearly average unless each week has a value in it. How can I get around this?

Thanks.

 

[Dearster]

Many thanks Jonmo1 for solving my problem. It was the average as a whole that I was looking for an this now working correctly to calculate the Year to data average.

Many thanks

 

[Jonmo1]

Glad to help.