Count of Values in Single Column

[akvpv6]

Good Morning,

I am trying to determine the best formula to use to capture how many times a value shows up in a single column. In the attached image I am trying to obtain a count for every time one of the Hold Reason Notes shows up in the column. Example - in the first 5 rows the formula would count 1 - ? 1 - Automated Special Billing Hold 1 - Discount and 2 - Incentive.

I feel that it will be a countif function but I don't know how to have it count when there are multiple options.

Thank you!

 

[Fluff]

How about like

=countifs(a$2:a2,a2)&" - "&a2

 

[akvpv6]

How about like

=countifs(a$2:a2,a2)&" - "&a2

How about like

=countifs(a$2:a2,a2)&" - "&a2

I think this is close to what I was looking for, is there anyway to have a formula with one of every option with the count next to it? I think I did a poor job explaining in my initial post.

? - total times this shows up in the data
Automated Special Billing - total times this shows up in the data
Incentive - total times this shows up in the data

 

[Fluff]

How about

=LET(u,UNIQUE(FILTER(A2:A1000,A2:A1000<>"")),HSTACK(u,COUNTIFS(A:A,u)))

 

[akvpv6]

How about

=LET(u,UNIQUE(FILTER(A2:A1000,A2:A1000<>"")),HSTACK(u,COUNTIFS(A:A,u)))

That worked out great, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.