Excel: How to get total number of times substring occurs in a range

Question

I have an excel document, and I want to be able to total the amount of times a substring (A name) occurs in that range. This is a picture of a table that I would want to use this formula on.

Thanks for your help in advance

Scott Craner · Accepted Answer · 2016-08-11T16:52:59.860

2

Use Countif with wildcards. It will look at the substring:

=COUNTIF($B:$D,"*" & G5 & "*")

edited Aug 11 '16 at 16:52

answered Aug 11 '16 at 16:14

Scott Craner

148,073
10
49
81

Thank you that was very quick and exactly what I needed. – Greg Potts Aug 11 '16 at 16:33

Excel: How to get total number of times substring occurs in a range

1 Answers1