Count values in a colum

STEELER934

im trying to count all the different values in equipment type section with a countif statement and i can figure out what im doing wrong can someone please assist to what the correct code would be please.

Carson Penticuff

=COUNT(DISTINCT([EQUIPMENT TYPE]:[EQUIPMENT TYPE]))

STEELER934

unfortunately this just told me there was 1 distinct value i need to know how many cb460 there how many em 400 there are things like that but do it to the whole sheet

Carson Penticuff

If you create an additional column, this will tell you how many items in the [EQUIPMENT TYPE] column match. Not a perfect solution...

=COUNTIFS([EQUIPMENT TYPE]:[EQUIPMENT TYPE], [EQUIPMENT TYPE]@row)