Hi elf4278

Sorry for the slow response I was in the land of nod. Yep that is
right the range is arbitrary. You change the range to whatever is
appropriate.

I would have a second table say it started in E2 with the names

John
Jane
Joe
Betsy

In F2 put =SUMPRODUCT(($B$2:$B$7=E2)*($C$2:$C$7))/COUNTIF($B$2:$B
$7,E2)

This would refer to John, drag this formula down and it will encompas
the other 'Editors' and do the same for the standard deviation
formula. Your range will probably go from $B$2:$B$122

Anyways good luck and if you have any trouble send me the
spreadsheet. Happy to help.

Marcus