# Count number of equal values in two rows in Excel

I have a spreadsheet that looks like this: A, B, C, D, 10 A, B, X, Y, 10 A, B, C, D, 20 The first line is a template. Latter lines are actual data. I want to count number of correct values for each line. Correct value is a value that is equal to corresponding… Read More Count number of equal values in two rows in Excel