Hi All,
I want to know the best way to use a Countif function together with Index and Match function. I need to count e.g. truck colours red, but relating to only company A not B and C. My dilemma at the moment is the countif brings all the counts red but only need the count for the specific company.
Any help very much appreciated.