IF/COUNT Statements Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

treen333@gmail.com - 18 Jun 2007 21:59 GMT

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

Reply to this Message

Rick Rothstein (MVP - VB) - 18 Jun 2007 22:06 GMT

> 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

Reply to this Message

T. Valko - 18 Jun 2007 22:07 GMT

Try this:

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

Biff

> I'm trying to get a count on a column that has two conditions. The
> conditions are:
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

bj - 18 Jun 2007 22:08 GMT

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

> I'm trying to get a count on a column that has two conditions. The
> conditions are:
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Jovan Timotijevic - 18 Jun 2007 23:54 GMT

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

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

Jovan Timotijevic

> I'm trying to get a count on a column that has two conditions. The
> conditions are:
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Teethless mama - 19 Jun 2007 04:52 GMT

Try this:

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

> I'm trying to get a count on a column that has two conditions. The
> conditions are:
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message