Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

SUMIFS Between 2 Dates Where Dates Reside In Cells

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

    Thanks in advance for any help you may provide!
    Last edited by mrnarley; May 26th, 2008, 04:16.

  • #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)

    Comment


    • #3
      Re: Reference Eomonth Date Ranges To Sum Totals

      It worked! Thanks!

      Comment

      Trending

      Collapse

      There are no results that meet this criteria.

      Working...
      X