average question

[celticdog]

Hi folks

I have creted a excel sheet to track the blood glucose level of my diabetic dog. He can have up to 12 readings per day, so ther are 12 coulums named reding 1 through to 12. The there is a daily avarge. However this is where I am lost, if all the daily readings a blank then I get a DIV/0 error, now this isn't that much of an issue. But I have a weekly, monthly and 14 avrage so when I email it to the vet every week they can see the on going avarage. At the moments the forumla is =AVERAGE(C2,E2,G2,I2,K2,M2,O2,Q2,S2,U2,W2,Y2)

How can I get it ignore blank cells?

I have attached the spreedsheet too.

Any help would be great

Jim