sum, not count money column in between date columns
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)
"benjo4u" wrote in message
...
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
|