Hi
do you mean
=SUMIF(Y2:Y1211,"=" & DATE(2004,1,1),AC2:AC1211)-SUMIF(Y2:Y1211,"=" &
DATE(2004,2,1),AC2:AC1211)

For getting the January values

"zach f" wrote:

Hello, I am trying to sum the total $ amount we are paying on an invoice by
month. I have things on this invoice that go back to January 2004. My dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am trying to
do this on a seperate worksheet from all of my data.

Thanks