Require help to count number
Solved/Closed
ebrahimrta2489
Posts
1
Registration date
Friday August 1, 2014
Status
Member
Last seen
August 1, 2014
-
Aug 1, 2014 at 09:16 PM
ebrahimrta - Aug 4, 2014 at 12:32 AM
ebrahimrta - Aug 4, 2014 at 12:32 AM
Related:
- Asistencia472.com
- Count number of occurrences in excel - Guide
- Count names in excel - Guide
- How to hide subscriber count - Guide
- How to make facebook app require password at sign in - Guide
- Does yahoo require a phone number - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 1, 2014 at 10:08 PM
Aug 1, 2014 at 10:08 PM
ebrahimrta2489, Good evening.
Suppose your above list is at A1:A19
Try to use:
ARRAY FORMULA
=SUM(LEN(A1:A19)-LEN(SUBSTITUTE(A1:A19,"1","")))
CTRL+SHIFT+ENTER
The result must be 22. Isn't it?
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose your above list is at A1:A19
Try to use:
ARRAY FORMULA
=SUM(LEN(A1:A19)-LEN(SUBSTITUTE(A1:A19,"1","")))
CTRL+SHIFT+ENTER
The result must be 22. Isn't it?
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
