I have a column of data (A2:A53) which represent 2007 week ending dates,
(linked to cells of 52 worksheets).

I have a column of Data (B2:B53) which represents the hours worked for each
week, (also linked to cells of 52 worksheets). For weeks not worked yet, the
value is zero, (right now there are zeros in cells B13:B53).

I would like the average of the hours worked for the entire year, and I
would like the average of the hours worked between Cell B7 and B53.

If there were no zero's I could use the following formulas:

=(SUM(B2:B53))/(COUNT(A2:A53))
=(SUM(B7:B53))/(COUNT(A7:A53))

I think I should use a couple of if statements something like <<< IF a some
cells are =0, subtract the count from the ranges in the formulas , But I
don't know how to state this in Excel terms.

Can someone give me a hand?

Thanks
Darrell