COUNTIFS function not showing result

[Schlesien]

I have a list of 22557 items that include duplicates of 2275 items. What I want to do to is to use COUNTIFS to determine how many instances of each of the 2275 items there are. The formula is =COUNTIFS($A$2:$A$22558,“0500000US01001”) where the item number in the quotation is one of the 2275 in the list that is also in the 22557 list. I can type it in manually and hit enter and get a number. However, when I copy and paste the rest of the 2275 items it only shows the formula and not the result. I don’t have the time to type each one manually. I am using the following version

Attached is the spreadsheet:
PROBLEM FORMULA.ods (63.2 KB)

So what is the problem?

[Schlesien]

It was not working previously before I copied this into a new file to prepare this post (and forgot to change from “CA” to “A”. Once I did that worked in this new file. However, the previous file never did work.

[Steph1]

I slightly changed the formula and copied it. The sum looks OK.
PROBLEM FORMULA.ods (70.3 KB)

[Villeroy]

Duplicates.odb (943.0 KB)
Database where the combination of hex number and category has 176 duplicates or triples. The form shows all duplicates/triples with their related records below.

[PKG]

@Schlesien ,
I recommend using a pivot table (Data → Pivot table).
PROBLEM FORMULA_Pivot.ods (70,9 KB)

[karolus]

@Schlesien
About Libreoffice… do you recognize the button right of Version Information ?
this is the button to copy the relevant Info to the clipboard ( to paste from … ) !!