I can't get countifs to work.

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

I reckon you want
=SUMPRODUCT(--(B6:AL6=$B$4:$AL$4))

Try instead:

=SUMPRODUCT(--($B6:$AL6=$B$4:$AL$4))

change Z4 to same as what is entered in Z5 (i.e. 31452)

I have seen your file and no need of the long formula you have written in the workbook. Just explain how you would like to get the total and the method of arriving the total. Finally please fill 2 or 3 rows of data manually with expected result for our easy understanding.

Maybe this will help...

It's called a Double Unary

hopefully jeffrey's link has answered your question?

please don't forget to mark the thread solved