I have a 88 randomnly organized numbers from 16 to 736 of days in which a radio trasmisor breaks, I need to make excel count how much numbers are from 16 to 96, from 96 to 176, etc.( for each range of [16,96), [96,176)... ) But I can't find how to do it, I know a function that is "countif" but this function only responds to a one thing like ">=16".

   ni   

[16,96)
[96,176)
[176,256)
[256,336)
[336,416)
[419,496)
[496,576]
[576,656]
[656,736]

Someone know what's the exact formula to do it? since excel can automatically translate functions maybe it will be valid in any language.

Here I put it on google drive, to show what it is document

1 decade ago*

Comment has been collapsed.

Try using countif function but with something like this:

=16 AND <96

1 decade ago
Permalink

Comment has been collapsed.

Closed 1 decade ago by lordcataclysm10.