Thank you for all your help. I wound up figuring it out by manually writing
in the dates. I am not sure why the formula I originally used did not work
in the first place but when I added the $ signs, it seemed to work just fine.
This is what I wound up using to achieve the desired result:

=SUMIFS($M:$M,$I:$I,"=1/1/2006",$I:$I,"<=1/31/2006")

Once again,

Thank you
"T. Valko" wrote:

You don't have to but then how would you identify a particular result?

Try this:

If you want to start from 1/1/2006...

Enter this formula in A2:

=DATE(2006,ROWS(A$2:A2),1)

Enter this formula in B2:

=SUMIFS(M:M,I:I,"="&A2,I:I,"<="&EOMONTH(A2,0))

Select both A2 and B2 and copy down as needed.

A2:An will return the 1st of the month for each month/year.


--
Biff
Microsoft Excel MVP


"Josh Hendrickson" wrote in
message ...
Thank you for the response T. Valko. I was hoping to do this for every
month
from 2006 to 2009. Do I have to put each date into a separate cell?

"T. Valko" wrote:

Use cells to hold your date boundaries:

A1 = 12/1/2006
B1 = 12/31/2006

=SUMIFS(M:M,I:I,"="&A1,I:I,"<="&B1)


--
Biff
Microsoft Excel MVP


"Josh Hendrickson" wrote in
message ...
I have a list of revenue broken down by transaction for the past four
years.
I want to see the total amount of revenue generated during the month of
December 2006 v. December 2008. Right now, my dates on the spreadsheet
are
in the form 12/31/2006. What type of formula should I use to do this?

I have tried this but it is coming up with nothing and I can see that
there
were sales during the month of December 2006.

=SUMIFS(M:M,I:I,"<=(12/31/2006)",I:I,"=(12/01/2006)")

Thank you for all of your help offered.