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,832
    Thanks
    136
    Thanked 484 Times in 461 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,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 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
  •