Calculate stats from multiple csv files

Hi Fletch,

I attach the solution for you.

The file is ready to receive your data, just open each csv file in excel and separate it into columns with Text to Columns Command, then copy and paste it in B2.

Copy and paste formulas down until your last record

The process in summary:

You can do it with the COUNTIF function.

Count the number of Questions 1 with Scored 0 and divide by the number of questions 1... and this way with each question.

Each question has two conditions:
Question 1: Scored 0 = 10 and Question 1: Scored 1 = 11
Question 2: Scored 0 = 20 and Question 1: Scored 1 = 21

Use concatenate function to turn those two conditions into one: 10, 11, 20, 21 ...

Done

I hope this help you

You can know more about COUNTIF function and examples in: http://www.excel-spreadsheet-authors.com/countif.html