averageifs with 3 criteria

[Crowie_12]

Hi all,
I am having problems sorting out a formula that can include all of my criteria.
I need to find the average (column C- RR Interval) only if there is more then 2 values recorded in the past 7 days (Column B) for a participant (Column A- Name).
Example is below:

Name	Date	RR Interval
AB	26/01/2015	1093.7
AB	27/01/2015	1276.9
AB	28/01/2015	1175.7
AB	29/01/2015	1210.1
AB	30/01/2015	1230.1
AB	31/01/2015
AB	1/02/2015	1064.3
AB	2/02/2015
AB	3/02/2015
AB	4/02/2015
AB	4/02/2015
AB	5/02/2015
AB	6/02/2015
AB	7/02/2015	1102.4
AB	8/02/2015	1147.2
AB	9/02/2015	1150.7
SC	10/02/2015	1189.1
SC	11/02/2015	1137
SC	12/02/2015
SC	13/02/2015
SC	14/02/2015
SC	15/02/2015
SC	16/02/2015	1149.2
SC	17/02/2015	1187.6
SC	18/02/2015	1191
SC	19/02/2015	1198.3

<tbody>
</tbody>

What I have so far is AVERAGEIFS(C:C,B:B,"<="&B2,$B:$B,">"&$B2-7,$A:$A,$A2) .... but this averages all values even if there is 2 or less values between the two dates.

Any help would be appreciated.

 

[mart37]

maybe a combination of: if, countifs and averageifs