Forum Discussion

wr2013's avatar
wr2013
Copper Contributor
Mar 16, 2024

Counting the number of occurrences of an entity in a table

I am trying to automate the counting of the number of times a country appears in a table.  See below example.              This table is original.                                                    ...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 16, 2024

wr2013 

One of several solutions.

=SUM(--ISNUMBER(SEARCH(D2,$A$1:$A$6)))
wr2013's avatar
wr2013
Copper Contributor
Mar 16, 2024

Detlef_Lewin 

I tried your formula and it just returned the number "1" for each line, but should have returned a "6" for the last two country lines.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 16, 2024

    wr2013 

    Try confirming Detlef_Lewin's formula by pressing Ctrl+Shift+Enter.

    The other one will only work in Excel in Microsoft 365.

    • wr2013's avatar
      wr2013
      Copper Contributor
      Mar 16, 2024
      I still only get the number "1" in each row.

Resources