Excel Help (CountIF)

triggerthat · 26 Apr 2010 at 11:06

Hi guys,

I need a condition that counts all figures that is in the range of 1-10. I've got the following but it doesn't work:

=COUNT(D7: D9,">0",",=10")

Any ideas?

wozencl · 26 Apr 2010 at 11:11

=COUNT(D7

9,">0",",=10")

triggerthat · 26 Apr 2010 at 11:14

Using a range of 1,0,2 it returns 3. Why does it count 0?

wozencl · 26 Apr 2010 at 11:47

COUNT counts all numeric values.

You need to use a combination of it and COUNTIF, something like the below should do it.

Count all numeric values - those greater than 10 - those less than or equal to 1.

Code:

=SUM(COUNT(A1:A7) -COUNTIF(A1:A7,">10") -COUNTIF(A1:A7, "<=0"))

fretted · 27 Apr 2010 at 22:31

or this?

=countif(a1:a7,">0")-countif(a1:a7,">10")