Counif using a range

C

cdb

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")
 
A

Andy B

Hi

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

--
Andy.


cdb said:
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") ? ?
Click to expand...
countif(A:A,">30")
 
C

cdb

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


cdb said:
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") ?
Click to expand...
countif(A:A,">30"
 
Top