It was a little unclear to me, but I believe your criteria you mention were
to be applied to the D range?

Array** formula:

=AVERAGE(IF((ISNUMBER(D$2:D$31))*($B$2:$B$31=$B36) *($D$2:$D$31<0)*($D$2:$D$31<=75),D$2:D$31))

**Use Ctrl+Shift+Enter to confirm, not just Enter


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ted" wrote:

This is the average formula I am using right now:

{=AVERAGE(IF(ISNUMBER(D$2:D$32),(IF($B$2:$B$31=$B3 6,D$2:D$31))))}

B2:B7 are the 7 days of the week, Monday through Sunday
D2:D32 are 31 days worth of numerical data

This formula finds the average for just the Wednesdays. It ignores blanks.
And it works great.

However I want to modify it to also ignore any 0's and any numbers greater
than 75. I can get it to do one of the two but not both.

Thanks any advance for any help.