Thread: Average of last 10 days

=AVERAGEIF($D$2:$D128, @TODAY()-($A$2:$J128)<11)AND($E$2:$E128="B"),$D$2:$D128)))

This is suppose to give the average blood sugar before Eating (as opposed to after eating) for just the past 10 days.

Keeps erring out.

Am I just completely off in my thinking?

Thanks in advance for the help.

don