DCOUNT Help

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)
 
A

Aladin Akyurek

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.
 
Top