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
1652
1646
1650
1658
1622
1651
1659
1582
1599
1606
1611
1657
1745
1937
1936
1648
1666
1656
1636
if i type like this in diffrence cell i want know how many 1 in total cell or any other number i want count

2 replies

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
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
0
Thank you very much for help
I solve my issue
0