I have a large amount of data- 2000 lines

stock code/ description/ depot sold to / qty sold

what I want to do is count the amount of stock codes in that sheet.

So product 'A' might appear up to 20 times at diferent depots and more than
once at a depot. But I just want to count A as 1 occurance.

When I pivot it counts the amount of times that product appears.

But I just want to know that e, I have 20 products occuring in the list..

Is there a pivot function to do this?