Try this:

SELECT field1 AS site,COUNT(DISTINCT field2) AS Cells_working ;
FROM mytable ;
GROUP BY 1 ;
INTO CURSOR result

You were almost there. You just needed the DISTINCT keyword to count the number of *different* cells for each site.

--Brad