I Have a attendance sheet that is out of 10 weeks, and a seperate formula to colour each week’s attendance from red to green etc. At the end of the 10 weeks there is a column that represents the total amount of weeks present (example, 4/10) with the function of (‘4/10) to not change to a date. Next to this column is another column with a precentage, for example (4/10 = 40%) is there any way i can make this automatic so when i update the /10 scale, the percentage updates automatically?

​I Have a attendance sheet that is out of 10 weeks, and a seperate formula to colour each week’s attendance from red to green etc. At the end of the 10 weeks there is a column that represents the total amount of weeks present (example, 4/10) with the function of (‘4/10) to not change to a date. Next to this column is another column with a precentage, for example (4/10 = 40%) is there any way i can make this automatic so when i update the /10 scale, the percentage updates automatically?  Read More

​