Aggregate a sheet by name as well as date

Question

Hi I'm trying to show an overview of data but am having trouble doing filters/sorts.

Here is a data set:

Name    Date    Points
Bob     10/20   10
Ruth    10/20    5
Joe     10/20    2
Bob     10/21   20
Ruth    10/21   23
Joe     10/21   16

I'm trying to have an overview that contains some following columns

Name    Last Updated    Average Points
Bob     10/21           #
Ruth    10/21           #
Joe     10/21           #

My pseudo formula would look like (in the last updated column)

• Find all rows named Bob (or A2 in this case)
• Sort by date
• Sum the rows and average by the count

I've been screwing around with filter, and can't even get that to work correctly:

=FILTER(UserData!A:C, UserData!A = A)