Hi Lenze,

Thanks for responding. I'm not sure how to attach a sample data sheet, so I attached a screen shot of what my data looks like. Basically, I'm attempting to calculate the Accuracy and RT values for various Visual Targets Groups (1-6). Column A is the Accuracy column, so a 1 = Correct and 0 = Incorrect. Column B is the Reaction Time (RT) column in ms that it took a participant to respond. Column C denotes the various Target Groups.

I would like to calculate the Mean Accuracy (based on the group of values in Column A) that correspond to each one of those Visual Target Groups (1-6). (So for instance, I would like to average rows 2-8 in Column A to create the "Average Accuracy" for Target Group 1).

Then, eventually, I would like to calculate the Mean and Median RTs (based on the values in Column B) for each of those Visual Target Groups (in Column C) that has received a Correct Response (denoted in Column A). (So in this instance, I would like to average rows 2-5 in Column B for "Mean RT" for Target Group 1 because those are events in Target Group 1 that also received a "1" in Column A).

Does that make more sense or is that more convoluted? Thanks again for your help!