Formulae for Percentage of 2 Cells

[HaudYerWeesht]

Hello

I am trying to find the formula that will give me the percentage of 2 cells on my training spreadsheet. A1 is attended and A2 is not attended. If 6 people attended and 2 people didn't, what formula would I use to work out the percentage of attendance.

A1 = 6
A2 = 2

Total = 8

I know it will be 75% and 25% but I would like a formula as there is a lot more cells to cover.
Thanks for any help

 

[jtakw]

Hi,

Seems like you've already answered your own question, unless there's more to it:

Book1
	A	B	C
1	6	Attended	75.00%
2	2	Not Attended	25.00%
3			Column formatted as Percentage
Sheet10

Cell Formulas
Range	Formula
C1	=A1/SUM(A$1:A$2)

C1 formula copied to C2.

 

[HaudYerWeesht]

Thank you so much! I knew what the answer was going to be for that particular cell but I have other cells with different amounts and I could not work out the formula that would automatically calculate it for me. Thanks again

 

[jtakw]

You're welcome.