YTD Percentage Formula

Is there a formula that I may use to keep track of the YTD percentage of attendance of volunteer workers over the course of a year? I have approx 200 workers meeting once a week. Their names are listed in column "A" from A-4 to A-204. Starting in column "E" is the date of the weekday for attendance.
For Example: E-1 is dated Jan. 7, 2008. F-1 is dated Jan. 14, 08 etc. I place a one (1) in the corresponding cell to show that they attended. The formula I need would start in cell D-4 and be dragged down to D-204.
There also must be a way to factor in the weeks which we are to meet that must be cancelled due to weather etc. The worker should not be penalized due to our cancellation.
Thank you for your help.

=COUNTIF(A1:EZ1,1)

gives you the number of attendances

assuming you put a C in when you cancel

=COUNTIF (A1:EZ1,"c") gives you how many times you cancelled

assuming you enter a 0 for a non attendance,

=countif(A1:EZ1,0) gives you non attendances

assuming you insert a blank row between each row

IN B1 enter the formula
=if(A2="",ytdcalc,"")

ytdcalc is obviously your YTD calculation of 100* attendances (1's)/possible attendances (ie 1's plus 0's)derived from above formulae

sorry error

in A2 enter the formula

if(B1="",ytdcalc,"")

robert111,
Thanks for your reply but I'm having some trouble with this. If you will advise how to zip this file to you, I'll be happy to do so.
I'm not as up to snuff as I need to be.

If you go to Windows Explorer and right click on your file, there should be an option in the menu to either Compress or WinZip your file. Let us know if that's not the case.

ChemistB

I'm getting 6 options:
1) extract to:
2) extract to here:
3) extract to folder; my documents.....
4) email sheet
5) create self extractor (.exe)
6) configure

I have used winzip in the past to get sheets to excel forum but I must have forgotten how I did it.
I'm not seeing any option that will get the sheet from my docs to excel forum. I hate to have to be led by the hand but I'm not doing so well by myself.
If you can help, I'd greatly appreciate it.