I have a table where I want to count the number of times "*VPN*" appear
in column A where column K is blank, something like:

=SUMPRODUCT(--($A$6:$A$1000="*VPN*"),--($K$6:$K$1000="")).

The result should be 14 but is returning 0. The countif formula

=COUNTIF($A$6:$A$1000,"*VPN*")=14 and the corresponding rows in
K6:K1000 = "".

What is wrong? TIA

Greg