在MS-Excel中计算两列中具有非零值的行数

I have an excel file with two columns. Let it be the ratings that different users have given for two movies. The movies represent the columns and the users represent the rows. I need to find the number of instances where a user has rated both the movies, in other words, how to find the number of rows where the two columns are both non-zeros.I have an excel file with two columns. Let it b