How to count entries in Google Sheets?

Question

Google Sheets

Google Sheets has a table like this:

On another page, you need to display the number of records for each status. This method works in mysql, but in Google Sheets it gives an error.

=QUERY('trcklv лиды'!A1:G;"
  SELECT
    C, D, E,
    SUM(IF(F = 'lead', 1, 0)),
    SUM(IF(F = 'sale', 1, 0)),
    SUM(IF(F = 'trash', 1, 0)),
    SUM(G)
  GROUP BY C, D, E
")

Mistake:

Failed to interpret query string. Details: Parameter 2 in the QUERY:PARSE_ERROR function: Encountered "(" at line 4, column 23. Was expecting: ")" ...

Answer 1

You need a COUNTIF function