Per the ANSI-92 standard:

1. COUNT(*) returns the cardinality of a table.

2. COUNT(column) applies the value expression to all rows of the table, then eliminates all rows where column is NULL.

SQL Uses Three-valued logic, as describes in more detail here: http://www.sqlservercentral.com/columnists/mcoles/fourrulesfornulls.asp