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    Apr 13, 2013
user Tom Saether :(!category-topic/docs/spreadsheets/d-1blwR8RmA)
Array Formula - Count Elements trouble

Hi. I have this sheet:

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