Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DSum Formula (XL 97; SR-2)

    I'm attempting to create criteria that would DSUM a date for a particular month. I have attached an XL file with an example of the formula that I am currently using. From days of old ie Lotus; I recall being able to set the criteria with a month formula such as:

    Criteria Example- Selecting February ie Month = 2
    DATE
    +Month(A8)=2


    Does anyone have any suggestions?
    Attached Files Attached Files

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DSum Formula (XL 97; SR-2)

    I don't see any way to do that using DSUM without adding another column that extracts the month from the date. Howwever, it can be easily done using an array formula. See the attached workbook.
    Attached Files Attached Files
    Legare Coleman

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DSum Formula (XL 97; SR-2)

    Thank you. The array formula did the trick.

Posting Permissions

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