Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: SUMIFS Between 2 Dates Where Dates Reside In Cells

  1. #1
    Join Date
    9th January 2008
    Posts
    22

    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 at 04:16.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th April 2007
    Location
    England
    Posts
    675

    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. #3
    Join Date
    9th January 2008
    Posts
    22

    Re: Reference Eomonth Date Ranges To Sum Totals

    It worked! Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Numbers Representing Dates To True Dates
    By billyj in forum EXCEL HELP
    Replies: 7
    Last Post: June 30th, 2008, 09:31
  2. Replies: 3
    Last Post: April 4th, 2008, 15:12
  3. Pass Control Dates To Cells As Dates Not Text
    By Fazered in forum EXCEL HELP
    Replies: 2
    Last Post: February 14th, 2008, 09:37
  4. Add To Dates Based On Criteria & Flag Overdue Dates
    By Big Dog Dad in forum EXCEL HELP
    Replies: 10
    Last Post: January 9th, 2007, 04:22
  5. Replies: 4
    Last Post: February 14th, 2006, 18:45

Bookmarks

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