我正在尝试使用 countif 来计算名称,但只希望当旁边的单元格显示“是”时才继续计数。
例如
George Yes Count for George would be 1<br>
Andy No Count for Andy is 0<br>
George No Count is still 1 for George<br>
Bob Yes Count for Bob is 1<br>
George Yes Count is now 2 for George
etc
我当前的代码是=IF(COUNTIF($E$3:E5,E5)=0,"",COUNTIF($E$3:E5,E5))
。它显示计数而不考虑“是”或“否”。