Array Average - Multiple Conditions?
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.
|