I'm trying to output the names of all donors of $100,000 or greater per week
of giving. I know how to sum all the money or the count all greater than
$100k, but this is in between. My best guess is:

=SUMPRODUCT((All!D2:D4998>="100000")*(M49<=All!H2:H4998)*(N49>=All!H2:H4998)*(All!Q2:Q4998))

where d is the dollar amount, m and n are the bookend dates to compare to h,
the row's date, and q is the name of the fellow. I want an output like "John,
****, Harry" Should I try something like

=SUM(IF(AND(All!D2:D4998>="100000",M49<=All!H2:H4998,N49>=All!H2:H4998),All!Q2:Q4998,""))

or even

=SUM(IF(All!D2:D4998>="100000",IF(M49<=All!H2:H4998,IF(N49>=All!H2:H4998,All!Q2:Q4998&", ",""),""),""))