+ Reply to Thread
Results 1 to 2 of 2

dvar Criteria overlap the list

  1. #1
    Registered User
    Join Date
    01-15-2020
    Location
    netherlands
    MS-Off Ver
    OFFICE 365 WINDOWS
    Posts
    1

    dvar Criteria overlap the list

    Hello Excel forum, This is a little bit difficult to explain but i am trying to find a way to use dvar where where the criteria is not a range. So B2 is my header and B4 is my criteria but it takes b3 also in count! How can i for example exlude B3?


    Untitled.png

    A link where i can find the basics to understand these kind of things would also be appreciated, thank you!
    Last edited by Derp9000; 02-09-2022 at 11:57 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,375

    Re: dvar Criteria overlap the list

    Administrative Note:

    Welcome to the forum.

    Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using DVAR
    By Jonathan9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2017, 12:57 PM
  2. Sum of Value overlap dates criteria
    By qfreud in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-17-2016, 09:38 AM
  3. I need to subtotal times from a list where they overlap.
    By jtpryan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-25-2014, 04:12 PM
  4. I need to subtotal times from a list where they overlap.
    By jtpryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2014, 12:53 PM
  5. [SOLVED] determine total overlap time when there are gaps in overlap (4 date ranges)
    By miriambender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 11:58 PM
  6. Replies: 0
    Last Post: 08-14-2013, 11:21 AM
  7. [SOLVED] Cross-checking list to determine overlap of entries
    By rhodesp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2013, 03:52 PM

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