# Summarizing a range of numbers
**URL:** https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785
**Category:** Ask for Help
**Created:** [October 5, 2023, 3:33pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785 "2023-10-05T15:33:27Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@CloudedHouse](https://community.glideapps.com/u/CloudedHouse)
#### Post date: [October 5, 2023, 3:33pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785/1 "2023-10-05T15:33:27Z")
My users will have a number entry field where they must enter a number between 8 - 45, I then want to to summarize the quantity of entries between 8 - 30 and 30 - 40. So that the number of entries between the two ranges are displayed. EG: 15 are between 8 - 30
I can see that someone asked a similar question and the solution is to use an If-Then-Else-If column but seems to require the results to populate different columns, although I could be wrong.
I’ll be glad of any help and suggestions
Thanks
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 5, 2023, 3:44pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785/2 "2023-10-05T15:44:12Z")
> [@CloudedHouse](#):
>
> I can see that someone asked a similar question and the solution is to use an If-Then-Else-If column but seems to require the results to populate different columns, although I could be wrong.
That how I would do it. Create separate IF columns for each range that you want to check. You could have the IF column return 1/0 or true/false. Then a couple of Rollup columns can Sum or Count the 1’s or true’s for each range.
Finally a template column can join those Rollup value with any additional verbiage.
---
### Author:  [@CloudedHouse](https://community.glideapps.com/u/CloudedHouse)
#### Post date: [October 5, 2023, 4:08pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785/3 "2023-10-05T16:08:18Z")
I haven’t done the roll up yet, but does this look right? Seems as though I’ve done something wrong
---
### Author:  [@CloudedHouse](https://community.glideapps.com/u/CloudedHouse)
#### Post date: [October 5, 2023, 4:10pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785/4 "2023-10-05T16:10:29Z")
Sorry, I meant to say I haven’t made the template column yet
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 5, 2023, 4:14pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785/5 "2023-10-05T16:14:59Z")
> [@CloudedHouse](#):
>
> Seems as though I’ve done something wrong
Seems correct to me. What doesn’t look correct to you?
---
### Author:  [@CloudedHouse](https://community.glideapps.com/u/CloudedHouse)
#### Post date: [October 5, 2023, 6:44pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785/6 "2023-10-05T18:44:16Z")
It just seems odd to have all rows with the same result
Because I end up with this
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 5, 2023, 7:26pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785/7 "2023-10-05T19:26:20Z")
What are you expecting to see? Your collection doesn’t appear to be filtered in any way, so yes, it’s going to show the same results on each row.
Hard to say what exactly you need to do. That depends on your end goal and what you want to see on the screen. Once I know that, then I can give you advice.
---
### Author:  [@CloudedHouse](https://community.glideapps.com/u/CloudedHouse)
#### Post date: [October 5, 2023, 7:35pm UTC](https://community.glideapps.com/t/summarizing-a-range-of-numbers/66785/8 "2023-10-05T19:35:20Z")
I think I’ve cracked it, the ‘Totals’ looks weird which comes from the ‘THEN’ section in the If-Then-Else-If column and requires the field to be populated with something, but I’ll decide later what to do with that
Many thanks
