sum, not count money column in between date columns

[Guest]

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),All!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

 

[Bob Phillips]

That formula should work okay if the data is good. Did you array enter it
(Ctrl-Shift-Enter)? What did you get?

--

HTH

RP
(remove nothere from the email address if mailing direct)