Counting Occurrences

[maxflia10]

Would anyone have a way to do this in one formula, come up with 5 in one formula? Rather the sum the occurrences.

Book1
	A	B	C	D
1	1	30	0	5
2	2	35	1
3	3	40	1
4	4	24	0
5	5	35	1
6	6	26	0
7	2	37	1
8	3	47	0
9	4	34	1
Sheet1

 

[phantom1975]

Here you go:

Book1
	A	B	C	D
1	1	30	5
2	2	35
3	3	40
4	4	24
5	5	35
6	6	26
7	2	37
8	3	47
9	4	34
Sheet2

 

[maxflia10]

Now why didn't I think of that?

 

[phantom1975]

Now why didn't I think of that?

It happens to me ALL the time.

 

[Yogi Anand]

Or the following array formula ...

=COUNT(IF(A1:A9>=2,IF(A1:A9<=5,IF(B1:B9>=30,IF(B1:B9<=40,A1:A9)))))

 

[maxflia10]

Or the following array formula ...

=COUNT(IF(A1:A9>=2,IF(A1:A9<=5,IF(B1:B9>=30,IF(B1:B9<=40,A1:A9)))))

Thanks Yogi!