Countif to recognise different text

[RunHard]

Hello again,

I am using countif to count a range of cells D10:D34 returning a PB as a result of a formula in Col D. The countif formula (=Countif(D10:D34,"PB") is in cell D39 and the result in D39 populates a cell in another worksheet. The formula in Col D also returns =PB results. I have placed another Countif formula in cell D41 (result to also populate a cell in another worksheet) to count all =PB's using (=Countif(D10:D34,"=PB"). The second countif doesn't work correctly. It counts all PB's and =PB's. Any suggestions.

Thanks
RunHard.

[DonkeyOte]

Perhaps

=COUNTIF(D10:D34,"?PB")

[RunHard]

DonkeyOte,

Exactly what I was after.

Thanks once again

RunHard