```A, B, C, D, 10
A, B, X, Y, 10
A, B, C, D, 20```

The first sentence serves as a model. Actual data are in the later lines. On each line, I want to count how many correct values there are. The correct value is one that corresponds to the value in the template line. Hence, the second line should be three, and the third line should be four.

I tried using COUNTIF, but I couldn't come up with an expression for the condition. Since SUMPRODUCT counts all pairs of equivalent values without regard to location, it also doesn't appear to be helpful in this situation.

Mar 21 in Others 81 views

## 1 answer to this question.

Use this formula:

`=SUM(--(A2:E2=\$A\$1:\$E\$1))`
• 38,010 points

## Find occurrence count of a number in Excel

First split those integer values into their ...READ MORE

## How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

## Count unique matches between two rows in Excel

The formula should be (in Excel 365) =SUM(--(COUNTIF(Draws!\$B\$2:\$G\$18,B2:K2)>0)) so ...READ MORE

## Spell number in excel 2013 using 2 rows

Hello, there are a few steps to ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE