Sumproduct OR adding criteria to Countif, Counta and Average

I trying to convert the following formula (I, II, III) and add criteria if Name, Date to the count values of “c”

CURRENT FORMULA

I: “=COUNTIF(C2:C3100,"<=6")” versley (B) and today to last 7 days (A)
II: “=COUNTA(C2:C3100)” versley (B) and today to last 7 days (A)
III: “=AVERAGE(C2:C3100)” versley (B) and today to last 7 days (A)


Add additional criteria

Date (A ): (A2:A3100<=TODAY())*(CA:A3100>=TODAY()-7))
Name (B): B2:B3100="vensley"
Count (C): Less than conditions


Sorry if I was not clear enough and appreciate any help

Date Received Team Grade
15-Jan-10 Susan 9
22-Jan-10 William 10
27-Jan-10 Mike 10
11-Feb-10 Mike 7
6-Jan-10 vensley 0
7-Jan-10 vensley 6
15-Jan-10 vensley 3
15-Jan-10 vensley 8



Wm…