As you have it the formula interprets AH3 and AH4 as text strings not cell references, try
Here is my formula:
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!
Last edited by mrnarley; May 26th, 2008 at 05:16.
There are currently 1 users browsing this thread. (0 members and 1 guests)