I'm trying to find out the score of my students using the COUNTIF function, but it's not working and I can't figure out why.
I'm uploading the .xlsx file with each of their answers, and in the last line the correct answers.
I used the following formula =COUNTIF(A2:CL2;A$42:CL$42)
But I keep geting 0 as return, even tho there are matches! Why?
What is your expected answer
Punnam
You mean this ?
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
=SUM(INDEX((A2:CL2=A$42:CL$42)*1,0))
try this
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks