# Averaging numbers that users input then displaying **URL:** \ **Category:** Ask for Help\ **Created:** [January 20, 2020, 7:25pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808 "2020-01-20T19:25:02Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![jaymccabe](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@jaymccabe](https://community.glideapps.com/u/jaymccabe)\ **Post date:** [January 20, 2020, 7:25pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/1 "2020-01-20T19:25:02Z")
I am using the number Number Entry Component to gather a ranking from users. However, number input by users overwrites each other instead of generating a list of numbers. What I am trying to do is get a list of numbers input by users then display an average to users. More specifically, the app is asking the users to rate a beer (1-10), then I would like to average the rankings then display them so users can get an aggregate average from the input. ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [January 20, 2020, 7:46pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/2 "2020-01-20T19:46:09Z")
You need to use a form, in which you will have a number entry. Each time a user will submit the form with his rating, a new row will be added. ---
**Author:** ![jaymccabe](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@jaymccabe](https://community.glideapps.com/u/jaymccabe)\ **Post date:** [January 29, 2020, 10:50pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/3 "2020-01-29T22:50:14Z")
When I use the Number Entry Component, the user input writes over itself ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [January 29, 2020, 11:16pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/4 "2020-01-29T23:16:56Z")
Or you using a form? A form should add a new row, not overwrite any existing row. ---
**Author:** ![jaymccabe](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@jaymccabe](https://community.glideapps.com/u/jaymccabe)\ **Post date:** [January 29, 2020, 11:47pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/5 "2020-01-29T23:47:16Z")
OK, yes thank you. I have input the form button and added a number entry and it is adding rows. Perfect. However, This is serving as a ratings system which will ultimately be averaged. When the number entered rating one object is added to the column, then when the user ranks another object, it is added to the same column. So no differentiation between objects, all just lumped together. How can I create different columns for different objects (in this case beer!) ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [January 29, 2020, 11:53pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/6 "2020-01-29T23:53:18Z")
You need only one column I think, this column will contain the object name or ID. Then you can filter per object, or also have an inline list based on the column object, which will allow you for example to display, for each object, who rated and what was the rating. For the average rating, you’ll calculate the sum of the ratings for a given object, divided by the number of user ratings for this object. ---
**Author:** ![jaymccabe](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@jaymccabe](https://community.glideapps.com/u/jaymccabe)\ **Post date:** [January 30, 2020, 9:31pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/7 "2020-01-30T21:31:34Z")
OK, Iv’e looked over your suggestion but I cannot get the correct configuration to have each object get multiple user inputed ratings. I would then average the ratings per object and display them into the app. So far for an object I have created a form button to rate the object. This populates a new sheet with a column of ratings. however it is not differentiating between objects… Here is the link to the app… [https://go.glideapps.com/app/Gqp4v6F2A0fSdeCUFt9z](https://go.glideapps.com/app/Gqp4v6F2A0fSdeCUFt9z) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 30, 2020, 9:35pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/8 "2020-01-30T21:35:44Z")
You need another column in your form results sheet for the object name. In the form use the column value components to populate the column you created in the sheet. ---
**Author:** ![jaymccabe](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@jaymccabe](https://community.glideapps.com/u/jaymccabe)\ **Post date:** [January 30, 2020, 11:24pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/9 "2020-01-30T23:24:24Z")
First let me say that I totally appreciate your responses to my questions and your support. Second let me say that your suggestion worked perfectly. Thank you. ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [February 23, 2021, 7:10pm UTC](https://community.glideapps.com/t/averaging-numbers-that-users-input-then-displaying/3808/10 "2021-02-23T19:10:53Z")
Moved to Help & How To