Saturday, April 13, 2013

yogi_Count Instances Of S Status For Players in Column K From Data In Columns B And C


                                          Google Spreadsheet   Post  #1120
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 13, 2013
user Tom Saether :(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/d-1blwR8RmA)
Array Formula - Count Elements trouble

Hi. I have this sheet:

https://docs.google.com/spreadsheet/ccc?key=0AkqLPb6rElPAdEtGR1ozaUFTNnhwLTE3Z0lWeTg3cGc&usp=sharing

The Top List to the right, columns: S, D and Pts.

Under S, I want to count how many Survived (S) Jack has. Jack can be counted in B column and S in C column. 

Care to explain what I do wrong or edit toplist sheet correctly? ¨

I want to find all lines that have Jack in it, and count how many times he have survived.
----------------------------------------------------------------------------------------------------------------------
following is a solution to the problem