Counting name and flag in another sheet
I have a sheet that lists Muppets and a traffic light flag. In a sheet I'll use for dashboard matrix info, I want to count how many times each Muppet has each colour of flag. Each Muppet is listed in a column called Metric.
My countifs formula is returning a value of 0 when I know that Ms Piggy has one red flag (for example). I am using a single range in my lookup called Metric 1.
Grateful for any guidance.