Excel使用COUNTIF进行动态输入

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.

我正在尝试使用单元格值(在F8中)在另一个工作表的B列中输入要搜索的关键字(在同一个工作簿中出现了Sep Miss)。我想返回一个总计数，其中输入可能是一个整体或部分匹配。B $是BC -我将在行之间拖动复制。

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*")  

1 个解决方案

#1

You are very close. Something like:

你非常接近。喜欢的东西:

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