Count (*) , (1) or (-1) counts all rows even if there are NULL values in the table

Insert the Column Name in the Brackets (Col1) then it will...