count nums syntax

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

i would like to count the number of times the number1 appears in
column L.
what is the proper syntax for this formula?
TIA
 
Larry,

You can use the COUNTIF function to do this. E.g.,

=COUNTIF(L1:L100,1)
 
Hi Larry,

=SUM(LEN(L1:L1000)-LEN(SUBSTITUTE(L1:L1000,"1","")))
 
Larry, just to clarify a couple of the reponses you have had, only your question was slightly
ambiguous in that you could interpret it two different ways:-

1) Chip has given you a solution that will count every cell that has 1 and only 1 in it. 11 in a
cell would not get counted as 2, in fact it would not get counted at all (Which may well in fact
be what you want)

2) Bob has give you a solution that will count every instance of the number 1 in the cells in your
range. 11 would be counted as 2 lots of 1, 111 would be counted as 3, 101214171 would be counted
as 5 instances.

Your call, but just be sure you really get what you want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Using LEFT() in COUNTIF 2
How to subtract a number from a Mergefield? 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Syntax suggestion beneath formula bar 2
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
MULTIPLE IF STATEMENTS PULLING DATA FROM MORE THAN ONE COLUMN 3
Counting 'up' rows instead of down 1

Back
Top