Hi,

I have a spreadsheet with a little over 1500 participants. Each participant was given a task 20 times; however, not all 20 trials show up for each participant (either they were too slow, hit escape by accident, etc.). All I need is an a total of how many trials each participant got correct. The problem is I can't run a formula down the column because not all participants have the same number of rows.

For privacy reasons I can't upload the file.

I am not familiar with VBA, and would prefer to do this via formulas. If anyone has any suggestions or questions I would love to hear them!