Calculating users in each slab

[g18c]

Hi, I would like to be able to count the number of users which fall in to progressive slabs as below:

SLAB_A (1 to 10 users)
SLAB_B (11 to 20 users)
SLAB_C (21 to 200 users)
SLAB_D (201 to 500 users)

As some examples, the counts should be:

User count of 5, SLAB_A = 5, and the other slabs would be 0.
User count of 15, SLAB_A = 10, SLAB_B = 5, and the other slabs would be 0.
User count of 100, SLAB_A = 10, SLAB_B = 10, SLAB_C= 180 and the remaining SLAB_D would be 0.
User count of 202, SLAB_A = 10, SLAB_B = 10, SLAB_C= 180 and the remaining SLAB_D = 2.

I have set my columns out on my spreadsheet as

Please Login or Register  to view this content.

I would like a user count for each slab row, slabs may be added in future so ideally it would need to be flexible.

Any ideas how I would do this please?

[Pepe Le Mokko]

If only I knew what a slab is....

[g18c]

Hey Pepe, slab is just a term for the count of users in a particular range - can reword the post if that would make it easier to understand?

[Pepe Le Mokko]

Perhaps like this ?

[g18c]

Perfect!!! Thanks so much, i hadn't thought to do it that way