Count with multiple conditions
I created an excel spreadsheet for a Survivor pool at work
I enter a name in a cell (sheet 2, A1) that corresponds to the person on redemption island, in this case Fransesca (see attached)
I need to count how many times players names appear in the row and in the column matching the value in A1 (Fransesca)
for example, in my attachment, Clair appears twice in the column, and Janine appears twice, 1 in the column and 1 in the row. I have a list on Sheet 2
|