You can include multiple conditions in a filter by using multiplication (which means logical AND). For example,  

    FILTER(D:AH, (A:A=A2) * LEN(E:E) * LEN(H:H))

requires A to be equal to A2 **and** E to be nonempty **and** H to be nonempty.

Conditions can also be combined using addition, which stands for logical OR:

    FILTER(D:AH, (A:A=A2) * (LEN(E:E) + LEN(H:H)))

requires A to be equal to A2 **and** that either E **or** H be nonempty.