# Thread: counting the x;s and the ci's

1. ## counting the x;s and the ci's

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.

2. ## Re: counting the x;s and the ci's

=COUNTA(A1:A5)&"/"&COUNTIF(A1:A5,"X")

where you data in in A1-A5

3. ## Re: counting the x;s and the ci's

=COUNTIF(CI:CI,"x")

?

4. ## Re: counting the x;s and the ci's

I think CI is just a mark not a column total number of non empty cells ie. marks and total number of X's 5/4

5. ## Re: counting the x;s and the ci's

Try...

=TEXT(COUNTIFS(A:A,"?*"),"000")&"/"&TEXT(COUNTIFS(A:A,"x"),"000")

6. ## Re: counting the x;s and the ci's

Originally Posted by Drrellik
I think CI is just a mark not a column total number of non empty cells ie. marks and total number of X's 5/4
Ahh now I've got it, she asked for the ratio. You are right @Drrellik

Then if CI is a column header, maybe it would be better to start range from A2

=COUNTA(A2:A5)&"/"&COUNTIF(A2:A5,"x")

7. ## Re: counting the x;s and the ci's

Try...

=TEXT(COUNTIFS(A:A,"?*"),"000")&"/"&TEXT(COUNTIFS(A:A,"x"),"000")
This is even better for the formatting 005/004 just make sure you don't have the formula in column A unless you change to define the range

U51 -u59

9. ## Re: counting the x;s and the ci's

Originally Posted by Mrs Lyttle
U51 -u59
=TEXT(COUNTIFS(U51:U59,"?*"),"000")&"/"&TEXT(COUNTIFS(U51:U59,"x"),"000")

This excludes the formula blanks and true numbers.

10. ## Re: counting the x;s and the ci's

Thank You so very much.