I have a table, where two columns contain similar data. I want to count the number of rows, where these are identical.

I found a solution, but it requires adding an extra row: suppose the two columns to compare are A and B, I add another column C with `=(A1 = B1)`

and so on and can then use `=COUNTIF(C1:Cn, "TRUE")`

.

Is it possible to count rows with identical columns without adding such an extra column? I tried using `COUNTIFS`

, but I can’t seem to get the syntax right.