Hello
I will start by saying I am awful with excel but learn fast and I'm a psychology student, this is data from an experimental game.
In column I is every single click made on a console, either "1" (for left) or a "3" (for a right). There are thousands and thousands of 1's and 3's in column I.
In Column K is the clicker id e.g. "10_263C34".
Each clicker id represents a person.
I want to find out how many 1's and how many 3's each person (i.e. each clicker id in column K) clicked.
Therefore I need something like "countif(I2:I432394243, "1" AND (corresponding row in K="10_263C34")"
"countif(I2:I432394243, "3" AND (corresponding row in K="10_263C34")"
There may also be a completely different formula to do this
Or it may be impossible
Thank you in advance
Imogen
Bookmarks