countif function

[Debbie]

Hi, I need help with a formula to count a range of numbers
within a column. For example:
A
16
21
18
21
32
44
50
65
I need to count how many are >30 and <=50
Results=3
Thanks.

 

[Dave R.]

Not countif, but try

=SUMPRODUCT((A1:A8>30)*(A1:A8<=50))

 

[Paulw2k]

=COUNTIF(A1:A8,">30")
=COUNTIF(A1:A8,"<=50")

 

[Max]

If using COUNTIFs, perhaps:

=ABS(COUNTIF(A1:A8,">30")-COUNTIF(A1:A8,"<=50"))

 

[b&s]

Max, are you sure?

--
regards/pozdrav!
Berislav

******************************************************************
ROT13 - email address (e-mail address removed)

 

[Max]

=ABS(COUNTIF(A1:A8,">30")-COUNTIF(A1:A8,"<=50"))

You mean the above suggestion ?
Yes, it does return the correct result: 3
So .. ?

 

[b&s]

Hi Max

If a range of numbers is:

33
21
18
21
32
44
50
65

formula doesn't return the correct result!
So..?

--
regards/pozdrav!
Berislav

*****************************************************************
ROT13 - email address (e-mail address removed)

 

[Max]

Hi, you're right !
The formula should be dismissed ..
Better stick to using SUMPRODUCT

Any idea how to get it bulletproof via the COUNTIFs route?

 

[b&s]

=COUNTIF(A1:A8;">30")-COUNTIF(A1:A8;">50")

--
regards/pozdrav!
Berislav

*****************************************************************
ROT13 - email address (e-mail address removed)

 

[Max]

Thanks !
You got it ..