Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Count items in a column 1
- Thread starter benny7
- Start date
-
1
- #2
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.
=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.
Example range is A1 to A10
=COUNTIF(A1:A10,"x")
=COUNTIF(A1:A10,"xx")
=COUNTIF(A1:A10,"xxx")
etc
=COUNTIF(A1:A10,"x")
=COUNTIF(A1:A10,"xx")
=COUNTIF(A1:A10,"xxx")
etc
- Status
Similar threads
- Locked
- Question