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

Colin Legg · #2 02-21-2011, 03:10 AM

Hi,

Please see if the attached is what you're looking for?

bundy5150 · #3 02-22-2011, 08:39 AM

It may work, the problem is I have the chart on a different sheet, and when I make the adjustments the answers don't all work out, some do, but others don't

Please see attached,

You'll notice that some are correct and others are not?

Thank you for your assistance on this, I am already learning a lot

bundy5150 · #4 02-22-2011, 09:03 AM

Oops, sorry

It works great? I realized I only typed the first half of the equation, Its all that appeared in the function bar (it wasn't until I pushed F2 until I saw the entire formula

Thanks for all your help

Colin Legg · #5 02-22-2011, 10:00 AM

Ah, sorry if that confused you. I have a habit of breaking long formulas into multiple lines (ALT+ENTER) at logical points so that I find them easier to read.

Code:

=IF(ISNUMBER(MATCH($K$2,$B$1:$H$1,0)),COUNTIF(INDEX($B$2:$H$10,,MATCH($K$2,$B$1:$H$1,0)),J3))
    +IF(ISNUMBER(MATCH($K$2,$A$2:$A$10,0)),COUNTIF(INDEX($B$2:$H$10,MATCH($K$2,$A$2:$A$10,0),0),J3))

Glad you've got it sorted now.

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