How to create a column that counts the total specified values form other columns?
It's easy to do this one in Excel with the "countif" function but, How can define a column that counts the total specified values from other columns?example: I have a table of the total answers, how can I count the right answer for each question?questionstudent 1student 2right answertotal answer1AAA22ABB13CBA0 thank you very much.