Use COUNTA to count cells that aren't blank

Source: support.content.office.net