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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work 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
All Courses

From novice to tech pro — start learning today.