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?
 
jimyXCommented:


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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
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.