I have to draw up panel setups for work and a lot of time goes into counting/listing how many of each panels there are, I've been looking into "count if" formulas and such with little success, so attached is an image with a few panels and a list how would I write a formula that would automatically tell me how many of each panels there are.
The cells are Merged
I have tried copying from YouTube a color counting formula but for some reason, it doesn't work