[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

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
0
JAaron Anderson
Asked:
JAaron Anderson
1 Solution
 
JAaron AndersonProgramming Architect @ Widener UniversityAuthor Commented:
like 3 should be 15qty instances but 9 should be 2qty instances
0
 
jimyXCommented:
use countif
0
 
nutschCommented:
From your sample data:

=COUNTIF(A1:F15,3)

But maybe you need something else.

Thomas
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
jimyXCommented:


So it becomes something like this:
=COUNTIF(A2:F16,I2)
0
 
Saqib Husain, SyedEngineerCommented:
=COUNTIF(A2:F16,3)
0
 
jimyXCommented:
Sample:
Sample.xls
0
 
JAaron AndersonProgramming Architect @ Widener UniversityAuthor Commented:
thx
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now