Calculate percentage meeting attendance month by month over the year

Hi everyone

I'm new to the forum and would really appreciate some help please

What I'm working on is a spreadsheet which has a row for each member organisation. There is a column for each meeting to be held during the year. Following each meeting a "1" entered to show the organisation was represented at the meeting and a "0" if no-one attended. The final column is to show the percentage of meetings attended by each organisation - at the moment it's simply the total of the "1"s divided by the number of meetings for the year. It's therefore only of any use until we get to the end of the year.

Is there any way that the end column could automatically calculate the percentage as the 1 or 0 is entered each month?

Any help would be greatly appreciated.

Thanks very much

Carol

Try
=SUM(Column)/COUNT(Column)
where Column is for example C2:C50
You can copy the formula forward .