Count items in a column 1

[benny7]

Hi

I have an Excel spread sheet with some fields in a column containing from 0 - 3 crosses (x). I want to count these crosses(x) and put a total at the end. Can this be achieved?

 

[lupins46]

If the cells contain croses or are empty then you can create a formula in the next column:
=len(a1)
(or whatver cell is relevant).
You can then sum this extra column.

Alternatively, in any cell type
=SUM(LEN(A1:A9))
and enter this as a range formula (Ctrl+Shift+Enter)
Use your own cell range obviously.

 

[xlhelp]

Example range is A1 to A10
=COUNTIF(A1:A10,"x")
=COUNTIF(A1:A10,"xx")
=COUNTIF(A1:A10,"xxx")

etc

http://www.geniusmedia.ca