percentage formula

[Anniemack76]

Hi everyone. Many moons ago I was fairly good at excel formulae. Then I had kids, stopped working and now excel will have changed a gazillion times since I last used it properly. I'm after some advice. I would like to have a spreadsheet that will tell me the percentage of a person's attendance at rehearsals over the year. So, ideally, I would mark down each time a person attends a rehearsal, and I would get a percentage of their attendance. Is there anyone out there that can help me with this??

Thanks in advance

[AliGW]

Are you asking about the layout of the worksheet or how to perform the calculation?

[Special-K]

Bit vague as we dont know the data layout so try baseing something yourself on this.
Assume Row 2 is a person's data
Column A is their name
Column B is percentage attended
Column C to L (10 columns) is whether they attended, it's either blank (they didnt attend) or X (they did).

in B2
=COUNTIF(C2:L2,"X")/10
format as a percent.

[Anniemack76]

Sorry Ali, I should have been more clear. I'm looking for the calculation.

[Anniemack76]

Thanks Special-K, I shall give this a go. Apologies for not being more detailed. First time poster!

[AliGW]

In that case, it's the number of attendances over the number of rehearsals multiplied by 100:

=(COUNTIF(C2:Z2,"x")/COUNT(C1:Z1))*100

where C2 to Z2 contains x whenever the person attended and C1 to Z1 contain the numbers (e.g. 1, 2, 3, etc.) or dates of the rehearsals.

[Anniemack76]

Special-K, thank you, this works to a certain extent. I have 52 dates in a year. As the dates pass, I want to record whether someone has attended the rehearsal to date so I will put an 'X' in that column. However, the percentage using this formula is taking into account all 52 dates, when some of these dates haven't happened yet. I need to record the %age based on the dates that have happened, so if a date in the future is blank, then this will affect the total percentage. Does this make sense? Will I need to edit the formula each week?

Thanks,
Anne

[Tony Valko]

Post some sample data and tell us what result you expect.