CODEWITHSUNDEEP
excelvbaexcel-formula
J.Mack
J.Mack

Reputation: 29

Excel use COUNTIF with dynamic input

I'm trying to use a cell value (in F8) to enter keywords to search for in column B of another sheet (Sep Miss which is in the same workbook). I want to return a total count where the input may be a whole or partial match. The $B is BC - I am drag copying across rows.

What I've tried: 

=CountIf('Sep Miss'!$B:$B, F8)  
=CountIf('Sep Miss'!$B:$B, "*F8*")  
=CountIF('Sep Miss'!$B:$B, Summary!F8)  
=CountIF('Sep Miss'!$B:$B, "Summary!F8")  
=CountIF('Sep Miss'!$B:$B, "*Summary!F8*")

Upvotes: 1

Views: 163

Answers (1)

Gary's Student
Gary's Student

Reputation: 96791

You are very close. Something like:

=CountIF('Sep Miss'!$B:$B, "*"&Summary!F8&"*")

Upvotes: 1

Related Questions