If you have a recordset with products on the page then the record count will be available from the bindings. If you want to get a count without showing the results you can do that with SQL. Just create a recordset like:
SELECT Count(*) AS ProductCount FROM ProductsTable WHERE manufacturer = 'the manufacturer'
Then you can display the ProductCount field from that recordset