Count with multiple conditions

bundy5150 · #1 02-17-2011, 08:49 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word count question	Wuffybrother	Word	3	03-22-2019 03:40 AM
Don't count hidden slides	Lu_Argentina	PowerPoint	0	10-12-2010 02:12 PM
Using Conditions to Add Values	EclipticalD	Excel	1	07-08-2010 09:50 PM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM
Don't count 0 in a chart	Rmaisone	Excel	0	08-21-2006 12:26 PM