Count Function

[OttawaBusinessContacts.com]

I jumped from fm5 to fm8 but I never used count functions. I am trying to count how many from each state or province in my data. I sorted it to ensure that we can advance properly. I thought of creating a trAnsient variable that i WOULD COMPARE THE STATE AGAINST BUT THERE HAS TO BE A SIMPLER WAY.

The final report would look like this:

FL 34

NY 143

VT 212

Grand Total