# How do i calculate the average vote **URL:** \ **Category:** Ask for Help\ **Created:** [May 16, 2020, 5:53pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252 "2020-05-16T17:53:27Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 16, 2020, 5:53pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/1 "2020-05-16T17:53:27Z")
I have movies, I have users, I have votes. A user gives a rating to a movie with a picker component (1-10). So every user sees his / hers own points. But how do I calculate the average points? So averyone can see the average? If I try to make a rollup column (I thought maybe that is the way to go to collect all personal points?) I only get count and count unique ? Hope someone can help! ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 16, 2020, 6:28pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/2 "2020-05-16T18:28:01Z")
You can use AVERAGEIFS if you want to do it in Google Sheets. Or, are you looking for a solution to do it in the Glide Builder? ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 16, 2020, 6:30pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/3 "2020-05-16T18:30:12Z")
Yeah, is it possible to do in Glide too? Because the votes remain in the data editor of Glide, I think. ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 16, 2020, 6:33pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/4 "2020-05-16T18:33:36Z")
Oh, are the votes captured in a user-specific column? I would assume so. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 16, 2020, 6:37pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/5 "2020-05-16T18:37:49Z")
Yes, that’s the case, seemed logical to me? ---
**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:** [May 16, 2020, 6:45pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/6 "2020-05-16T18:45:48Z")
I don’t think you can currently perform rollups on user specific columns. I think it is Glide’s goal to add that functionality at some point. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 16, 2020, 7:02pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/7 "2020-05-16T19:02:58Z")
ah ok, thanks, then i need a different route to follow 😉 ---
**Author:** ![Saul\_Delhom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saul_delhom/32/39097_2.png) [@Saul\_Delhom](https://community.glideapps.com/u/Saul_Delhom)\ **Post date:** [February 24, 2022, 4:25pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/8 "2022-02-24T16:25:16Z")
Old post but, it’s possible now? Make a sum or average of all user votes in a specific column. ---
**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:** [February 24, 2022, 4:54pm UTC](https://community.glideapps.com/t/how-do-i-calculate-the-average-vote/9252/9 "2022-02-24T16:54:37Z")
No, still not possible. You would have to do something like this. > [@Averaging Rating Data](https://community.glideapps.com/t/averaging-rating-data/28204/4): > > You can do it in a separate screen like this. [image] You would store the rating to a user-specific column that only serves as a temporary storage on the second screenshot. Let’s call it “temporary rating”. Force users to make a decision whether to “submit” or not. If they press submit you write that value to another column “permanent rating”, also a user-specific column. Serves only as a way to show the rating to the signed-in user later on. Now for the average, it gets a bit comp…