[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# Excel formula HowManyTimes a String Exists in Range

Posted on 2011-03-25
Medium Priority
223 Views

If I had the provided sample range, what formula could I make to count how many 3s there are all together ? thanks
I tried the following thinking it would work

``````=SUM(IF(ISNUMBER(FIND(I2,A2:F16)),1,0))
``````
sampledata.txt
0
Question by:JAaron Anderson
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

Author Comment

ID: 35217745
like 3 should be 15qty instances but 9 should be 2qty instances
0

LVL 24

Expert Comment

ID: 35217759
use countif
0

LVL 39

Expert Comment

ID: 35217761

=COUNTIF(A1:F15,3)

But maybe you need something else.

Thomas
0

LVL 24

Accepted Solution

jimyX earned 2000 total points
ID: 35217778

So it becomes something like this:
=COUNTIF(A2:F16,I2)
0

LVL 43

Expert Comment

ID: 35217783
=COUNTIF(A2:F16,3)
0

LVL 24

Expert Comment

ID: 35217802
Sample:
Sample.xls
0

Author Closing Comment

ID: 35218500
thx
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
New style of hardware planning for Microsoft Exchange server.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filledâ€¦
Progress
###### Suggested Courses
Course of the Month13 days, 5 hours left to enroll