count if odd or even

Hello FePerrella,

This is one way:

This solution requires an auxiliary column. In this case, the data is in B and column A is the auxiliary column. You can pick any columns and adjust the expressions. Then you may hide the auxiliary column if you wish.

The expression in Column A is:

=IF(MOD(B, 2)=0, "EVEN", "ODD")

The expression for counting odd results is: =COUNTIF(A, "ODD")

and, the expression for counting even results is: =COUNTIF(A, "EVEN")

I am not aware of any way, short of a script, to both calculate the evenness or oddness of each entry and do the count in one cell.

Jerry

So you just want to see if an odd (1 odd number) exist in the range (all the columns)?

FP,

You must be careful about fancy Excel expressions because they sometimes are doing matrix operations, which Numbers doesn't do explicitly.

Without seeing an example of your special circumstances, It's difficult to recommend a solution. Here's my solution, transposed:

Jerry

Hi FP,

However i don't want to create a new line for each IF sentence.

Try this. Create another table ('Odds') to test is a value is odd.

Formula in B2 of the Odds table (and Fill Right and Down)

=ISODD(Table 1::B2)

I added Conditional Highlighting to the Odds table to show green for TRUE. You can move the Odds table to another Sheet to 'hide' it if you want.

Formula in A2 of Table 1 (and Fill Down)

=COUNTIF(Odds::2:2,"TRUE")

Regards,

Ian.

Hello

Obviously you may calculate sum of MOD(n,2) for given numbers. Formula would become lengthy, though.

E.g.,

Table 1 (excerpt) A2 =MOD(B2,2)+MOD(C2,2)+MOD(D2,2)+MOD(E2,2)+MOD(F2,2) +MOD(G2,2)+MOD(H2,2)+MOD(I2,2)+MOD(J2,2)+MOD(K2,2) +MOD(L2,2)+MOD(M2,2)+MOD(N2,2)+MOD(O2,2)+MOD(P2,2) B2 =RANDBETWEEN(0,50) C2 =RANDBETWEEN(0,50) D2 =RANDBETWEEN(0,50) E2 =RANDBETWEEN(0,50) F2 =RANDBETWEEN(0,50) G2 =RANDBETWEEN(0,50) H2 =RANDBETWEEN(0,50) I2 =RANDBETWEEN(0,50) J2 =RANDBETWEEN(0,50) K2 =RANDBETWEEN(0,50) L2 =RANDBETWEEN(0,50) M2 =RANDBETWEEN(0,50) N2 =RANDBETWEEN(0,50) O2 =RANDBETWEEN(0,50) P2 =RANDBETWEEN(0,50)

Or you may introduce auxiliary columns to store MOD(n,2) for given numbers. Formula would be concise and easily filled.

E.g.,

Table 2 (excerpt) A2 =SUM(Q2:AE2) B2 =RANDBETWEEN(0,50) C2 =RANDBETWEEN(0,50) D2 =RANDBETWEEN(0,50) E2 =RANDBETWEEN(0,50) F2 =RANDBETWEEN(0,50) G2 =RANDBETWEEN(0,50) H2 =RANDBETWEEN(0,50) I2 =RANDBETWEEN(0,50) J2 =RANDBETWEEN(0,50) K2 =RANDBETWEEN(0,50) L2 =RANDBETWEEN(0,50) M2 =RANDBETWEEN(0,50) N2 =RANDBETWEEN(0,50) O2 =RANDBETWEEN(0,50) P2 =RANDBETWEEN(0,50) Q2 =MOD(B2,2) R2 =MOD(C2,2) S2 =MOD(D2,2) T2 =MOD(E2,2) U2 =MOD(F2,2) V2 =MOD(G2,2) W2 =MOD(H2,2) X2 =MOD(I2,2) Y2 =MOD(J2,2) Z2 =MOD(K2,2) AA2 =MOD(L2,2) AB2 =MOD(M2,2) AC2 =MOD(N2,2) AD2 =MOD(O2,2) AE2 =MOD(P2,2)

Regards,

H