Counting Even-Odd Numbers that are Less (or More) than a Certain Value

[kioutsoukov]

Hello

I have a row that consists of numbers.
I want to count how many numbers in that row are odd, more than 20 and less than 40 in one and single formula!

I would appreciate a respond
Thanks in advance

 

[barry houdini]

Hello and welcome to MrExcel

Assuming your numbers are in A2:Z2 you could use this approach

=SUMPRODUCT((A2:Z2>20)*(A2:Z2<40)*(MOD(A2:Z2,2)=1))

 

[Scott Huish]

Hi,
Welcome to the board!

=SUMPRODUCT(MOD(A1:Z1,2),--(A1:Z1>20),--(A1:Z1<40))

 

[Aladin Akyurek]

Hello

I have a row that consists of numbers.
I want to count how many numbers in that row are odd, more than 20 and less than 40 in one and single formula!

I would appreciate a respond
Thanks in advance

Let A2:N2 house the number set of interest and let...

A4: 20

B4: 40

C4, control+shift+enter, not just enter:

=SUM(IF(A2:N2>=A4,IF(A2:N2<=B4,1-(MOD(A2:N2,2)=0))))

 

[Scott Huish]

Assuming integers, MOD(x,2) will generate 1 if it is odd. I don't believe there is any need to do additional math or comparisons on it.

 

[kioutsoukov]

Hello and welcome to MrExcel

Assuming your numbers are in A2:Z2 you could use this approach

=SUMPRODUCT((A2:Z2>20)*(A2:Z2<40)*(MOD(A2:Z2,2)=1))

------
...and now, how can I count the EVEN numbers?

 

[barry houdini]

Just change the 1 at the end to a zero

=SUMPRODUCT((A2:Z2>20)*(A2:Z2<40)*(MOD(A2:Z2,2)=0))