I have tried the Microsoft help but the formula simply doesn't work. Attached sheet is a smaller/simplified version of what I'm trying to do with a set of data.
I have a table of data showing all instances of each colour, then I want to break it down into each colour within each shape. i could filter and count but my actual data is 8 different shapes & 31 different colours [data types changed to make it simpler]
I'm very new to formulas more complicated than sum etc so all help appreciated in the simplest of terms please.
Thanks
Bookmarks