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
wr2013's avatar
wr2013
Copper Contributor

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.