2 Comments - Last post 4 minutes ago by BattleChaing
2,257 Comments - Last post 7 minutes ago by MeguminShiro
58 Comments - Last post 11 minutes ago by MeguminShiro
42 Comments - Last post 12 minutes ago by MeguminShiro
58 Comments - Last post 14 minutes ago by MeguminShiro
698 Comments - Last post 17 minutes ago by MeguminShiro
47,272 Comments - Last post 35 minutes ago by misterhaan
31 Comments - Last post 6 minutes ago by Drae
22 Comments - Last post 8 minutes ago by miIk
114 Comments - Last post 11 minutes ago by eeev
29,156 Comments - Last post 18 minutes ago by afa1425
103 Comments - Last post 19 minutes ago by Eindirk
23 Comments - Last post 20 minutes ago by WaxWorm
69 Comments - Last post 30 minutes ago by BigDave
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".
[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
Comment has been collapsed.