Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Thread: SUMIFS Between 2 Dates Where Dates Reside In Cells

1. SUMIFS Between 2 Dates Where Dates Reside In Cells

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.

Last edited by mrnarley; May 26th, 2008 at 04:16.

Excel Video Tutorials / Excel Dashboards Reports

2. Re: Reference Eomonth Date Ranges To Sum Totals

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)

Excel Video Tutorials / Excel Dashboards Reports

3. Re: Reference Eomonth Date Ranges To Sum Totals

It worked! Thanks!

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno