Excel formula HowManyTimes a String Exists in Range


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
JAaron AndersonProgramming Architect @ Widener UniversityAsked:
Who is Participating?
 
jimyXConnect With a Mentor Commented:


So it becomes something like this:
=COUNTIF(A2:F16,I2)
0
 
JAaron AndersonProgramming Architect @ Widener UniversityAuthor Commented:
like 3 should be 15qty instances but 9 should be 2qty instances
0
 
jimyXCommented:
use countif
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
nutschCommented:
From your sample data:

=COUNTIF(A1:F15,3)

But maybe you need something else.

Thomas
0
 
Saqib Husain, SyedEngineerCommented:
=COUNTIF(A2:F16,3)
0
 
jimyXCommented:
Sample:
Sample.xls
0
 
JAaron AndersonProgramming Architect @ Widener UniversityAuthor Commented:
thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.