ExcelBanter - Countif between ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countif between ranges (https://www.excelbanter.com/excel-discussion-misc-queries/71809-countif-between-ranges.html)

BSantos

Countif between ranges

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

Dave Peterson

Countif between ranges

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

BSantos wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 02:46 AM.