I am using ArcMap 10.5. I have a table of species list length from visits to sites over a period of years. I have a column for site, giving the grid reference of each site, and a column giving the number of species recorded on that visit. I want to create a frequency table that tells me how many visits where 2 or more species were recorded were made to each site.

Essentially I want to run the 'Frequency' tool on the 'site' field, but only calculate frequency for the rows where the 'species' field is >= 2.

How can I do this?

  • 1
    Have you tried select by attributes rows with >=2 species then run frequency tool.
    – BERA
    Mar 13, 2020 at 14:05
  • 1
    Embarrassed not to have thought of that! Thanks!
    – Yusef_S
    Mar 13, 2020 at 14:36

1 Answer 1


Select by attribues rows >=2 species then run frequency tool. Only selected rows will be included.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.