Create an "other" countif bucket when value doesn't match range

better show what you did
or
attach example excel file (not a picture) with non-other and other.
desensitize data first

Something like:

=COUNTIF($A$1:$A$12,A14) for Burger King
=COUNTIF($A$1:$A$12,A15) for McDonalds
=COUNTIF($A$1:$A$12,"<>")-SUM(B14:B15) for Others

or another way for others: =COUNTIF(A1:A11,"<>")-SUMPRODUCT(COUNTIF(A1:A11,D1:D2)) where D1:D2 is a range where your selected companies are.

But there are many ways to achieve the same result

Just for fun

You can do that without any formula(s) but with PowerQuery (different ways)

This did the trick. Great idea to simply subtract matches from the total. Thank you so much

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it - ignore it.
Thank you.