Wildcards in Array formula

Hi All,
I'm working with several columns of data that represent the types of employees we have at my organization. I'm trying to count the number of each type by status, as well as determine the salary payments to each type.

My problem is that we have titles like "PAA I" "PAA II" and "PAA III" and I've not been able to quite figure out the right formula to deal with this problem.

The array formula I have been using is:

Please Login or Register  to view this content.

But that isn't returning the correct count. I tried using search, but that resulted in a "#value" error. The search formula I used is:

Please Login or Register  to view this content.

Any ideas? Thanks in advance for any help!

Cheers,
Tim

Tim try the below:

=SUMPRODUCT(--($P$24:$P$207="Prov"),--ISNUMBER(SEARCH("PAA",$O$24:$O$207)))

(for more info on Sumproduct see the link in my sig.)