=COUNTA(A1:A5)&"/"&COUNTIF(A1:A5,"X")
where you data in in A1-A5
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.
=COUNTA(A1:A5)&"/"&COUNTIF(A1:A5,"X")
where you data in in A1-A5
There are 10 types of people in this world, those who understand binary, and those that dont.
- forum use guidelines, forum rules and terms of use
- Try searching for your answer first, see how
- Read the FAQs
- List of BB codes
=COUNTIF(CI:CI,"x")
?
Last edited by Flashbond; Feb 21st, 2018 at 11:37 PM.
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
There are 10 types of people in this world, those who understand binary, and those that dont.
- forum use guidelines, forum rules and terms of use
- Try searching for your answer first, see how
- Read the FAQs
- List of BB codes
Try...
=TEXT(COUNTIFS(A:A,"?*"),"000")&"/"&TEXT(COUNTIFS(A:A,"x"),"000")
Assuming too much and qualifying too much are two faces of the same problem.
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")
Last edited by Flashbond; Feb 21st, 2018 at 11:46 PM.
There are 10 types of people in this world, those who understand binary, and those that dont.
- forum use guidelines, forum rules and terms of use
- Try searching for your answer first, see how
- Read the FAQs
- List of BB codes
U51 -u59
Last edited by Aladin Akyurek; Feb 21st, 2018 at 11:53 PM.
Assuming too much and qualifying too much are two faces of the same problem.
Thank You so very much.
Like this thread? Share it with others