Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2011
    Location
    Illinois
    Posts
    62
    Thanks
    17
    Thanked 2 Times in 2 Posts

    COUNTIF, or DCOUNT?

    If I have a spreadsheet of tabular data (column headings, not necessarily defined as a Table), is there any benefit to using COUNTIF vs. DCOUNT? COUNTIF is more straightforward to define, and doesn't require a criteria table, but I'm wondering if there are benefits to using DCOUNT that I'm missing?

    Excel 2013, if it makes a difference.

    Thanks for any thoughts! :-)

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,947
    Thanks
    140
    Thanked 517 Times in 493 Posts
    Hi

    Use the COUNTIF and/or COUNTIFS rather than DCOUNT.
    It is simpler.
    As you say, you need separate ranges for your criteria with the DFUNCTIONS, which can be inconvenient.
    (DFUNCTIONS are more efficient than equivalent array formulas)

    zeddy

  3. The Following User Says Thank You to zeddy For This Useful Post:

    13ILGal (2015-04-07)

  4. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,488
    Thanks
    376
    Thanked 1,472 Times in 1,340 Posts
    13ILGal,

    My advice would be to use CountIFs it the criteria are fairly simple. When the selection criteria start to get complicated I think you would do better with the DCount functionality. YMMV! HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. The Following User Says Thank You to RetiredGeek For This Useful Post:

    13ILGal (2015-04-13)

  6. #4
    Star Lounger
    Join Date
    Jan 2011
    Location
    Illinois
    Posts
    62
    Thanks
    17
    Thanked 2 Times in 2 Posts
    Agreed - far simpler for most use cases!

Posting Permissions

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