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     www.energyefficientbuild.com.   May 20, 2013
user Robert Warner (http://productforums.google.com/forum/?zx=ttx1g8rgpf8v#!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!
Rob
--------------------------------------------------------------------------------------------------------------------
following is a solution to the problem