Need help with Countif Formula

[squeakums]

On Issues w-out action plans, the name won't match exactly with F4, it has an initial for example John Smith or John Smith T.

I want it count if it finds the name similar under columns P:P, how would I write that into this code below please?

=IFERROR(COUNTIF('Issues w-out Action Plans'!P:P,'MoEVM Summary Level'!F4), "0")

 

[yky]

Try this:

=IFERROR(COUNTIF('Issues w-out Action Plans'!P:P,'MoEVM Summary Level'!F4&"*"), "0")