count values where two columns match

Options
BlairMyles
edited 12/09/19 in Formulas and Functions

i am trying to count the number of matching pairs of values in two columns.

eg:

Column A         Column B

1910                 760

1910                 810

1910                 810

1990                 760

1990                 760

the outcome of the above that i am looking for is as follows

 

1910 x 760 = 1

1910 x 810 = 2

1990 x 760 = 2

can someone please help me with a formula that will give me these count summaries?

 

Regards

 

 

 

 

 

 

 

 

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!