Saturday, September 15, 2012

yogi_Count Total Yes and No Values By Name And Email From Table in Sheet2

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #751   Sep 15, 2012

user Hudaiming said: (!category-topic/docs/spreadsheets/Wkji8qijMis)
Problem with formula (input value from other cell in filter formula)
I have been trying to solve some problem for almost 2h and I can't do it :S I hope someone can help me.
Please take a look at this spreadsheet:
There are two sheets. I am trying to count total "Yes" and total "No" from Sheet2 for specific users (in this case in Sheet 1 in columns C and D
I know that I can use this formula:
But because I have about 70 emails it would be hard for me to input each of the email manually in column C and D in Sheet1. I tried various options with importing email from column B, but it never worked.
I would appreciate if you could help me solve this problem. Thanks a lot!
following is a solution to the problem