IF/COUNT Statements Help

[treen333]

I'm trying to get a count on a column that has two conditions. The
conditions are:

If column J has an X and Column S has a P count this cell.

Can anyone tell be how to enter this formula?

Thanks

 

[Rick Rothstein \(MVP - VB\)]

I'm trying to get a count on a column that has two conditions. The

conditions are:

If column J has an X and Column S has a P count this cell.

Can anyone tell be how to enter this formula?

Give this a try...

=SUMPRODUCT((J1:J10="X")*(S1:S10="P"))

Rick

 

[T. Valko]

Try this:

=SUMPRODUCT(--(J1:J10="X"),--(S1:S10="P"))

Biff

 

[Guest]

try
=sumproduct(--(J1:J100="X"),--(S1:S100="P"))
the --( changes the logical true false to a numeric 1 0
the arrays must be the same size but cannot be an entire column
J:J won't work

 

[Guest]

Try this array formula (remember to finish it with Ctrl+Shift+Enter):

=SUM(--(J1:J14="x")*--(S1:S14="p"))

Jovan Timotijevic

 

[Guest]

Try this:

=SUMPRODUCT(--(J1:J100&S1:S100="XP"))