[SOLVED] COUNTIF COLUMN F="John Smith" AND COLUMN AE = TRUE ?

My problem is that I think in terms of SQL and not in terms of Microsoft Office logic....

I just want to count all rows where Column F has a certain value in text format, and Column AE is Boolean "TRUE".

e.g.
COLUMN F="John Smith" AND COLUMN AE = TRUE

But I can't figure out how to do it.... Does anyone know?

Try

=COUNTIFS(F:F,"John Smith",AE:AE,TRUE)