Countif between ranges

B

BSantos

Hi, does anyone know how to write a formula with the countif to do ranges.

example

countif
range 1-5
range 6-11
range 12-17
range 18 or more
 
D

Dave Peterson

=countif(a1:a10,">="&1) - countif(a1:a10,">"&5)


Hi, does anyone know how to write a formula with the countif to do ranges.

example

countif
range 1-5
range 6-11
range 12-17
range 18 or more
Click to expand...
 
Top