I am trying to use countifs in my spreadsheet to count the number of correct answers students make in a test. There are 35 fields and criteria. At first i got the error message 'MORE ARGUMENTS ARE SPECIFIED THAN ARE ALLOWED IN THIS FILE FORMAT'. I have Excel 2010. What file format should I be using?
When i saved the file as binary, that error message disappeared. But when I tested the formula, I get no response. I have attached the spreadsheet.
Can anyone help me please?
Thanks
Attachment 189047
Bookmarks