DCOUNT Help

  • Thread starter Thread starter Luke
  • Start date Start date
L

Luke

I am trying to use the dcount function to count how many
of each zip code I have in a mailing list. I am losing my
mind (short trip)
 
Try either to build a pivot table from your zip code data or to invoke a
CountIf formula after extracting a unique list of zip codes using Advanced
Filter.

If you insist on using a D-function, you'll need a unique list of zip codes
along with 'data table method'.

See http://makeashorterlink.com/?V55122CD5 which also describes other
methods involving D-functions.
 
Back
Top