+ Reply to Thread
Results 1 to 2 of 2

Help with DSUM using a named range with multiple criteria

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    Federal Way, WA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Help with DSUM using a named range with multiple criteria

    I use the DSUM formula to count the rows associated with a specific Day/Week/Dept/Person criteria.
    I'm using the following DSUM formula with a named range which works just fine with a single criteria:

    =DSUM(Table,ActHrs,R.FRED_MON)


    The named range is: =ActualHrs!$AN$64:$AQ$65
    The cells for the named range are:

    Day Week# Department ResourceName
    Monday 22 *325* *royf*


    What I want to do is be able to search for multiple departments. So I would want 325 OR 326 to be the department criteria. I've tried several different things here but am having no luck. Any help would be greatly appreciated!!

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013, 2016, 2019, 365
    Posts
    294

    Re: Help with DSUM using a named range with multiple criteria

    To include multiple criteria in a DSUM, you need to add another row to the criteria range. i.e. change the named ActHrs range to
    =ActualHrs!$AN$64:$AQ$66

    The criteria would become

    Day Week# Department ResourceName
    Monday 22 *325* *royf*
    Monday 22 *326* *royf*

    BE CAREFUL - if you leave the second row blank, then the DSUM includes all data!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1