Ask Your Question
0

Count rows for which certain columns differ

asked 2018-09-05 14:58:57 +0100

crater2150 gravatar image

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.

edit retag flag offensive close merge delete

Comments

heh... interesting consistency to ask "count rows for which certain columns differ" in title, and then ask how to count those that don't differ in the body :-)

Mike Kaganski gravatar imageMike Kaganski ( 2018-09-05 15:01:09 +0100 )edit

oops. I actually need both, so i got it mixed up during writing. I actually checked if my example matched the rest of the text, but forgot the title^^

crater2150 gravatar imagecrater2150 ( 2018-09-05 15:51:06 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-09-05 15:08:02 +0100

=SUMPRODUCT(A1:An=B1:Bn)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-05 14:58:57 +0100

Seen: 24 times

Last updated: Sep 05 '18