The number function counts all the cases whereas the count function gives the number of non-null values in the variable.