SUMIFS Between 2 Dates Where Dates Reside In Cells

[mrnarley]

Here is my formula:

=SUMIFS(O:O,C:C,">AH3",C:C,"<=AH4")

O:O contains accounting numbers.
C:C contains dates.
AH3 contains the following: =EOMONTH(AM2,-13) for an output date of 4-30-07. AM2 contains today's date.
AH4 contains the following: =EOMONTH(AM2,-12) for an output date of 5-31-07.

I'd like to sum the numbers where dates for those numbers fall between 4-30-07 and 5-31-07. I can't get it to work if I reference the cells that are using the EOMONTH formula, but can get it to work if I "hard enter" 4-30-07 in place of "AH3" and 5-31-07 in place of AH4. I don't get it.

Thanks in advance for any help you may provide!

[daddylonglegs]

As you have it the formula interprets AH3 and AH4 as text strings not cell references, try

=SUMIFS(O:O,C:C,">"&AH3,C:C,"<="&AH4)

[mrnarley]

It worked! Thanks!