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

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