Counting even numbers

[Trev752]

How do you count for even numbers in a row that are less than a certain value, like less than 50 lets say.

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?

24 02 21.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2	2	47	27	29	22	17	57	97	56	68	2
3	64	63	5	98	64	29	36	21	59	96	1
4	84	44	34	42	58	21	11	12	72	6	5
5	67	67	67	67	67	67	67	67	67	67	0
6	46	95	93	60	97	40	76	80	35	97	2
7	5	5	5	5	5	5	5	5	5	5	0
8	41	59	7	4	6	34	73	68	65	98	3
9	2	4	6	8	10	12	14	16	18	20	10
10	24	85	61	58	36	60	29	66	47	51	2
Count

Cell Formulas
Range	Formula
K2:K10	K2	=COUNT(FILTER(A2:J2,(A2:J2<50)*(MOD(A2:J2,2)=0),""))

 

[SunnyAlv]

Like this

List Item

=LET(data,EVEN(D4:D13),FILTER(FILTER(data,data<50),FILTER(data,data<50)<>0))

Count Data

=LET(data,EVEN(D4:D13),COUNT(FILTER(FILTER(data,data<50),FILTER(data,data<50)<>0)))

 

[SunnyAlv]

Like this

List Item

=LET(data,EVEN(D4:D13),FILTER(FILTER(data,data<50),FILTER(data,data<50)<>0))

Count Data

=LET(data,EVEN(D4:D13),COUNT(FILTER(FILTER(data,data<50),FILTER(data,data<50)<>0)))

View attachment 107202

my mistake, sorry this is wrong

 

[Trev752]

Welcome to the MrExcel board!

Is this what you mean?

24 02 21.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2	2	47	27	29	22	17	57	97	56	68	2
3	64	63	5	98	64	29	36	21	59	96	1
4	84	44	34	42	58	21	11	12	72	6	5
5	67	67	67	67	67	67	67	67	67	67	0
6	46	95	93	60	97	40	76	80	35	97	2
7	5	5	5	5	5	5	5	5	5	5	0
8	41	59	7	4	6	34	73	68	65	98	3
9	2	4	6	8	10	12	14	16	18	20	10
10	24	85	61	58	36	60	29	66	47	51	2
Count

Cell Formulas
Range	Formula
K2:K10	K2	=COUNT(FILTER(A2:J2,(A2:J2<50)*(MOD(A2:J2,2)=0),""))

Thats perfect, thanks. I keep forgetting about the Mod function. really appreciate it.

 

[Trev752]

Like this

List Item

=LET(data,EVEN(D4:D13),FILTER(FILTER(data,data<50),FILTER(data,data<50)<>0))

Count Data

=LET(data,EVEN(D4:D13),COUNT(FILTER(FILTER(data,data<50),FILTER(data,data<50)<>0)))

View attachment 107202

Thanks SunnyAlv, I'll use that in another one of my work sheets.​

 

[Peter_SSs]

Thanks @SunnyAlv, I'll use that in another one of my work sheets.

I would be very careful about doing that. The formula does nothing like what you were asking.

Thats perfect, thanks.

You're welcome. Glad to help. Thanks for the follow-up.

 

[Rick Rothstein]

Here is another formula that I think does what you want (note - the 5 is your 50 divided by 10)...

=SUM(COUNTIF(A2:J2,SEQUENCE(5,,0,10)+{0,2,4,6,8}))

 

[Peter_SSs]

Here is another formula that I think does what you want (note - the 5 is your 50 divided by 10)...

=SUM(COUNTIF(A2:J2,SEQUENCE(5,,0,10)+{0,2,4,6,8}))

If using a sequence approach, this seems to me to be simpler and more obviously related to the required conditions.

=SUM(COUNTIF(A2:J2,SEQUENCE(50/2,,0,2)))

Here is another pretty short one too

=SUM(ISEVEN(-A2:J2)*(A2:J2<50))