Conditional Formatting Formula - Multiple Criteria - SUM, COUNT, Exemption, exception

[Zelminar]

Hello Folks,

I've included a workbook with sample data as well as expected highlighting/conditional formatting to occur.

The criteria is as follows:
Highlight if sum of column D (SOLD) for a single person listed in Column A (INITIALS) is greater than 100 WHILE.
Exemption: ANY rows which may contain "DONE" in column E (VERIFY)

EXCEPTION: If the person in column A (INITIALS) only has ONE non-"DONE" row assigned, DO NOT highlight.


NOTE: You can SORT Column A in the "Expected OUTPUTEFFECT" sheet to better arrange and see the desired effect better.

I'm looking for both a DYNAMIC Range and a STATIC Range formula (I hope that's good wording).
The amount of rows per day in my case can fluctuate day to day from anything between 100-1000. For example, the static formula should consider the range A1:F1000 for highlighting; while the dynamic one should probably just be $A:$F

The following dynamic formula KIND OF work, but eventually DIDN'T and absolutely takes a long time to process thus my request for a more STATIC range formula as well. (I'm bad at making these things work haha)

=AND(SUMIFS($D:$D,$A:$A,$A1,$E:$E,"<>DONE")>100,COUNTIFS($A:$A,$A1,$E:$E,"<>DONE")>1)

(Hope I hand-typed that well)

environment: Using Office 365, and uploading to SharePoint for teams use.

Thanks in advance to all who participate!