cell to equal a count of a row and colum

**MYESKEY** · 10-13-2011, 10:58 AM

I am trying to make a cell count only if "c" has a name and "g" has an X in the row that lines up with "C" colum. =COUNTIF(C:C,"James A")*IF(G:G,"X") this is what I am trying but it is not working. Thanks for the help

**MUSTAFAINE** · 10-13-2011, 11:05 AM

Try below function;

Please Login or Register  to view this content.

**MYESKEY** · 10-13-2011, 11:14 AM

Thank you. I am trying to learn more and am glad I found this site.

**Fotis1991** · 10-13-2011, 11:23 AM

Mustafaine solution is OK, but please notice that:

1) IS Array Formula(trl+Shieft+Enter)

2) Not C:C, but C1:C65000(For Example)

3) One more ( )

Then works nice.

**Andrew-R** · 10-13-2011, 11:27 AM

1. It's not an array formula and doesn't need to be entered with CSE

2. C:C will be slower than C1:C65000, but will still work

3. It has the right number of brackets.

Other than that you're spot on

**Fotis1991** · 10-13-2011, 11:43 AM

Originally Posted by Andrew-R

1. It's not an array formula and doesn't need to be entered with CSE

2. C:C will be slower than C1:C65000, but will still work

3. It has the right number of brackets.

O.K I see that both of you are right. Very sorry for this...

Other than that you're spot on

Sorry i don't understand what you mean in your last sentence.