Hey guys,

I have a problem. My column looks like this. Need to calculate the number of occurances of ASA or AFR etc.. in the column A.

I need to use Dcount and a criteria to get this solution

Basically these abbreviations are Short forms for World Regions(Continents).

Criteria is somewhat like this

RGN XRGN

ASA TRUE

A1: AFR,ASA,EUR
A2: ASA,ANT,NAM
A3: ASA,EUR,SAM,AUS
A4: PCF,AUS

Help me out , thanks