counting the x;s and the ci's

[Mrs Lyttle]

Good evening I am in need of guidance. I have a spreadsheet that I need in each column the total number of marks / total number of x.

CI

x

x

x

x

005/004 I want to enter a formula that will give me the above ansewer. Help me please.

<colgroup><col></colgroup><tbody>
</tbody>

 

[Mrs Lyttle]

Thank You Sir