In the attached workbook I'm trying to get the average, filtered, that match three criteria. I removed the opening "=" to preserve what I have so far.
My best guess at this is "SUMPRODUCT(SUBTOTAL(101,OFFSET(M$1:M$2000,ROW(M$1:M$2000)-ROW(M$1),0,1,1)),--(H$1:H$2000=$A2),(M$2:M$2000,"<20"),(M$2:M$2000,">0"))".
Any help would be greatly appreciated!
Sick
Bookmarks