Counting name and flag in another sheet

Hi,

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.

Tags:

Answers