IF/COUNT Statements Help

T

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
 
R

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?
Click to expand...

Give this a try...

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

Rick
 
B

bj

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
 
J

Jovan Timotijevic

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

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

Jovan Timotijevic
 
Top