Running formula with uneven number of rows

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!

Can you upload fake data?
You can probaby use COUNTA in the last cell or for visibility add new column in front but if you need something more specific your data will be useful.

Start with a Pivottable (Menu:Insert:...

Select:
Row: Name
Column: Trials
Value: Count Names

The table will have a total.
This or something similar should solve your problem.
//Ola

Here is a sample file!

Something like this?
//Ola