MCQOPTIONS
COUNT(field_name) tallies only those rows that ..
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.