[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
7
Medium Priority
?
223 Views
Last Modified: 2012-05-11

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))

Open in new window

sampledata.txt
0
Comment
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
  • Learn & ask questions
7 Comments
 

Author Comment

by:JAaron Anderson
ID: 35217745
like 3 should be 15qty instances but 9 should be 2qty instances
0
 
LVL 24

Expert Comment

by:jimyX
ID: 35217759
use countif
0
 
LVL 39

Expert Comment

by:nutsch
ID: 35217761
From your sample data:

=COUNTIF(A1:F15,3)

But maybe you need something else.

Thomas
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 24

Accepted Solution

by:
jimyX earned 2000 total points
ID: 35217778


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

Expert Comment

by:Saqib Husain, Syed
ID: 35217783
=COUNTIF(A2:F16,3)
0
 
LVL 24

Expert Comment

by:jimyX
ID: 35217802
Sample:
Sample.xls
0
 

Author Closing Comment

by:JAaron Anderson
ID: 35218500
thx
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question