Not sure what I was doing wrong but I did get this formula to work for me-
thank you!

"JBeaucaire" wrote:

Worked for me when I changed the formula to look in the right year and month.

=SUMPRODUCT(--(DATE(YEAR($J$1:$J$200),MONTH($J$1:$J$200),1)
=DATE(2008,4,1)),$K$1:$K$200)

This is the piece you have to set:

=DATE(2008,4,1)

The bit is set to check April 2008. Adjust that for the months you want to
see. I got 110 when I made that bit:

=DATE(2008,3,1)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.

"Bsting" wrote:
That does not seem to be working for me either, I am still getting a #value! error
Here is some examples
Column J Column K
3/26/2008 110.00
04/03/2008 123.30
04/09/2008 79.00
06/16/2008 327.00
07/18/2008 47.70
07/01/2008 5,300.00
07/16/2008 188.93
09/30/2008 17,742.68
05/28/2008 324.16
04/22/2008 163.50
05/13/2008 2.25
04/22/2008 455.00
04/09/2008 66.33

Where Column J is the date the amount was paid and K is the amount that was
paid. With the above I want to be able to say how much was paid during the
month of March in 2008- which should return $110.00 but does not. The blank
rows are where no amounts have been paid to date. Both J and K are set to
dispaly as numbers.

Thanks