COUNTIF to SQL COUNT CASE / SUM

If the answer is one number, filter and COUNT(*). If you need a count per row in a report, use SUM(CASE…).

SELECT COUNT(*) FROM Orders WHERE status = 'Shipped';

-- or on a grouped report
SELECT customer_id,
       SUM(CASE WHEN status = 'Shipped' THEN 1 ELSE 0 END) AS shipped
FROM Orders
GROUP BY customer_id;

Wildcards: COUNTIF "*co.uk" is LIKE '%co.uk'.

Canonical translation

SELECT COUNT(*) FROM Orders WHERE status = 'Shipped';

-- or on a grouped report
SELECT customer_id,
       SUM(CASE WHEN status = 'Shipped' THEN 1 ELSE 0 END) AS shipped
FROM Orders
GROUP BY customer_id;