How to use something similar to COUNTIF() function

[ericachae]

Hi All,

I would like to count the same word in column A and B....

Counting all the repetitive word in result...

Thank you.

<BEFORE>

Analysis Type	WinLoss
Competitive	WIN
blind	WIN
Optimization	WIN
blind	WIN
blind	WIN
blind	WIN
Optimization	WIN
Optimization	LOSS
Optimization	LOSS
Competitive	LOSS
Competitive	LOSS
Competitive	LOSS
Competitive	LOSS
Competitive	LOSS

<AFTER>

competitive	blind	optimization	WIN	LOSS
6	4	4	7	7

[alexnajm · Accepted solution]

Here is a solution from your input that matches the output!

[ericachae]

This is exactly what I needed!!

Super thanks!

[alexnajm]

Happy to help!