On Mon, 2 Mar 2009 07:53:04 -0800, MiJa wrote:

I tried to create a hybrid of the 2 answers to my question because I do not
want to have additional cells for "1/1/2009" and "1/31/2009;" I need to do
this for each month so I want to incorporate it into the equation. My
equation is
=SUMPRODUCT(--(O19:O999=DATE(2009,1,1)),--(O19:O999<=DATE(2009,1,31)),Q19:Q999) but it just returns 0.00. Any suggestions?

If your data is in columns A & B, you didn't change the references.


To expand on my question, if I have 4 Jan dates in Column A I want to sum
the 4 corresponding amounts in Column B. The answer from Ron summed the whole
column B.

If my answer

=SUMIF(A:A,"="&DATE(2009,1,1),B:B) - SUMIF(A:A,""&DATE(2009,1,31),B:B)

summed the entire column B, and not just the January entries, then either you
did not enter it correctly, or there is something about your data that you have
not told us.

--ron