$csv = Import-Csv backlink_check_results.csv
$yes = ($csv | Where-Object { $_.ContainsLink -eq 'YES' }).Count
$no  = ($csv | Where-Object { $_.ContainsLink -eq 'NO'  }).Count
$err = ($csv | Where-Object { $_.Status -eq 'ERROR' }).Count
Write-Output "YES:$yes; NO:$no; ERROR:$err"
$csv | Where-Object { ($_.ContainsLink -eq 'NO') -or ($_.Status -eq 'ERROR') } | Export-Csv problematic_backlinks.csv -NoTypeInformation -Encoding utf8
Write-Output 'Wrote problematic_backlinks.csv'