Monday, May 20, 2013

yogi_Count How Many Times Cell In Column A Match Cell in Column B

                                          Google Spreadsheet   Post  #1203
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 20, 2013
user Robert Warner (!category-topic/docs/spreadsheets/37hRyo8VFWY)
Count how many times cell in column A match cell in column B
I want a sum of the number of times a cell in one column matches a cell in the same row but in a different column. For example, I have 2 columns with 3 different possible values (employee, manager, owner), and I just want to know how many times value in the first column matches the value in the second. Is this possible without having a third column without having a column full of countifs and summing it there?

Thanks for your help!
following is a solution to the problem