# Row Rollup **URL:** \ **Category:** Feature Requests\ **Created:** [September 6, 2020, 5:09pm UTC](https://community.glideapps.com/t/row-rollup/15371 "2020-09-06T17:09:16Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 6, 2020, 5:09pm UTC](https://community.glideapps.com/t/row-rollup/15371/1 "2020-09-06T17:09:16Z")
You know what would be swell? Having a Rollup of a ROW (sum, count, max, etc). I see the UI similar to an if then where you can select the columns (either via drop down or checklist) to be included in the Rollup. Would save me from having to write this mess of a formula for `COUNT`: `={"Total (K)_answers";ARRAYFORMULA(if(len(A2:A),iferror(1/(1/mmult(n($C2:$P="K"),transpose(n($C2:$P2)^0)))),""))}` and this one for `MAX`: =`{"Max";QUERY(TRANSPOSE(QUERY(TRANSPOSE(Q2:S), "select "®EXREPLACE(JOIN( , ARRAYFORMULA(IF(LEN(Q2:Q&R2:R&S2:S), "max(Col"&ROW(Q2:Q)-ROW(Q2)+1&"),", ""))), ".\z", "")&"")), "select Col2")}` With the hope that Glide Tables can replace Google Sheets, we’ll need functionality like this. @Mark @Antonio @david ---
**Author:** ![Roberto\_Salim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roberto_salim/32/6861_2.png) [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)\ **Post date:** [September 6, 2020, 5:36pm UTC](https://community.glideapps.com/t/row-rollup/15371/2 "2020-09-06T17:36:16Z")
It would really be good, I am also afraid of this transaction, the potential of formulas to find results and integration with scripts, losing this would be a setback. ---
**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\ **Post date:** [September 6, 2020, 5:38pm UTC](https://community.glideapps.com/t/row-rollup/15371/3 "2020-09-06T17:38:33Z")
+1 for this feature in native data editor ---
**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:** [September 6, 2020, 5:39pm UTC](https://community.glideapps.com/t/row-rollup/15371/4 "2020-09-06T17:39:56Z")
When I see a formula like this, Robert, I know I will never get there 😉 If Glide can help make formulas like this ‘Blom-proof’ it will win the world! ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 6, 2020, 8:20pm UTC](https://community.glideapps.com/t/row-rollup/15371/5 "2020-09-06T20:20:32Z")
Which properties in the row are you rolling up? How do you pick them? This makes sense for arrays, for sure. ---
**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\ **Post date:** [September 6, 2020, 9:14pm UTC](https://community.glideapps.com/t/row-rollup/15371/6 "2020-09-06T21:14:42Z")
In my case, I want ratings in a product review averaged. For instance, Taste (X out of 5), Packaging (X out of 5), and Cost-effectiveness (X out of 5) for a product rated by a user averaged to average Rating (X+X+X/3). Ideally, I would want it to work on User-specific columns as well. Btw, thanks for ‘listening’ to our feedback David. Appreciate it! ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 6, 2020, 9:56pm UTC](https://community.glideapps.com/t/row-rollup/15371/7 "2020-09-06T21:56:57Z")
Here you could use a Math column, right? Any reason you’d prefer a roll-up? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 6, 2020, 9:56pm UTC](https://community.glideapps.com/t/row-rollup/15371/8 "2020-09-06T21:56:58Z")
Numbers—determine max or sum Strings —determine count Boolean —determine count true ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 6, 2020, 9:57pm UTC](https://community.glideapps.com/t/row-rollup/15371/9 "2020-09-06T21:57:12Z")
Can’t do a math column with strings (count) …nor determine max