Counif using a range

[Guest]

If I have a list of amounts, what's the syntax to use to count the times a range of values appears

e.g. I need to know the formula for the ?'

Data (on sheet1

1



1
2
5
2

3

Calculations (on sheet2

Under 10 10-20 20-30 Over 3
countif(A:A,"<11") ? ? countif(A:A,">30")

 

[Andy B]

Hi

Try
=COUNTIF(A:A,">=10")-COUNTIF(A:A">20")
and
=COUNTIF(A:A,">=20")-COUNTIF(A:A">30")

--
Andy.

If I have a list of amounts, what's the syntax to use to count the times a range of values appears?

e.g. I need to know the formula for the ?'s

Data (on sheet1)

12
2
5
9
19
23
54
25
4
35

Calculations (on sheet2)

Under 10 10-20 20-30 Over 30
countif(A:A,"<11") ? ?

countif(A:A,">30")

 

[Guest]

Cheers

That seems to work fine

----- Andy B wrote: ----

H

Tr
=COUNTIF(A:A,">=10")-COUNTIF(A:A">20"
an
=COUNTIF(A:A,">=20")-COUNTIF(A:A">30"

--
Andy

If I have a list of amounts, what's the syntax to use to count the times range of values appears 3
countif(A:A,"<11") ?

countif(A:A,">30"