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
No comments:
Post a Comment