I recently got some help on counting the number of rows with data between
certain dates. Now I need to sum up a dollar amount in rows between certain
dates. As of now, I have

=SUM(IF(AND(M49<=All!H2:H5000,N49=All!H2:H5000),A ll!F2:F500,"0"))

where m49 and n49 are the range of the dates, H is the date column in the
worksheet and f is the money column in the worksheet. I also tried this with
a sumif function which didn't work.

and while I'm here, how would I output ideally the names of people donating
more than $100,000 or at least the number of people, again, within certain
dates

=SUMPRODUCT(--(All!F2:F5000="100000"),--(M49<=All!H2:H5000),--(N49=All!H2:H5000))

Thanks
-Benjamin