Counting matches in two columns

%3CLINGO-SUB%20id%3D%22lingo-sub-614600%22%20slang%3D%22en-US%22%3ECounting%20matches%20in%20two%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614600%22%20slang%3D%22en-US%22%3E%3CP%3EI%20ave%20a%20file%20with%20two%20columns.%20I%20want%20to%20count%20the%20number%20of%20particular%20matches%20between%20the%20columns.%20For%20example%20how%20many%20times%20is%20there%20%22number%22%20in%20one%20column%20and%20%22correct%22%20in%20the%20corresponding%20row%20in%20the%20other%20coumn.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-614600%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614718%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20matches%20in%20two%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614718%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344793%22%20target%3D%22_blank%22%3E%40VickyK%3C%2FA%3E%26nbsp%3B%2C%20I%20guess%20you%20may%20use%20COUNTIFS()%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I ave a file with two columns. I want to count the number of particular matches between the columns. For example how many times is there "number" in one column and "correct" in the corresponding row in the other coumn.

1 Reply
Highlighted

@VickyK , I guess you may use COUNTIFS()