Forum Discussion
countif exact text
Hi I have a formula that I am having issues with. My current formula is : =countif($D18:$018,"*"&AC$13&"*") AC13 = P1 D18-O18 is my range of cells However this also counts cells that co...
If you want to count instances of both P1 and p1, use COUNTIF like this:
=COUNTIF(D$18:O$18,AC13)
Nonetheless, use any of these if you want to count instances of P1 only and exclude p1:
1. Array formula (confirmed with Ctrl+Shift+Enter):
=SUM(--EXACT(D$18:O$18,AC13))
2. Non-array formula (confirmed with regular Enter):
=SUMPRODUCT(--EXACT(D$18:O$18,AC13))
The choice is yours!