IF/COUNT Statements Help

  • Thread starter Thread starter treen333
  • Start date Start date
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
 
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
 
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
 
Try this array formula (remember to finish it with Ctrl+Shift+Enter):

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

Jovan Timotijevic
 
Back
Top