countif in a large file

I need to futher process the data after so i rather not use a PT if its possible. il try to attach a sample of the file

Countif (and Countifs) does seem to be slow with 84k rows of data.
Vlookup on the other hand, isn't.
You can use a Pivot table (or a Power Query query) as a lookup table.
I used 130k rows of data, one set with almost as many distinct items as there are rows of data (like your data), and another set with only 16 distinct values.
The first set makes for a big lookup table, and for this, the pivot table was faster at updating than the Power Query (although Power Query wasn't that slow).
For the second set the difference wasn't noticeable.

Using a Pivot table as a lookup table isn't that easy as the size of the table varies with your source data and there's no super easy way to refer to the Pivot table's range changes.
Using a VLookup on a Power Query query is super easy because the reference to the query table remains the same, regardless of its changing size.

Whether you use the pivot or the query it needs to be refreshed if the source data changes (this can be automated). Right-clicking and choosing Refresh does this manually.

In the linked-to file here, (too big to attach I suspect) I've included both methods, and a tiny macro to give the name PVLookup to the pivot table range straight after the pivot's been refreshed, which name is used in column A.

The Power Query query is short and straightforward.
The 260k formulae in columns A and B take a trivial amount of time to update.

Other things I tried:
Advanced Filter to get a unique list of numbers - very slow indeed
GetPivotData formula - very slow