# Array column summary **URL:** \ **Category:** Ask for Help\ **Created:** [May 20, 2021, 9:37am UTC](https://community.glideapps.com/t/array-column-summary/27007 "2021-05-20T09:37:59Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [May 20, 2021, 9:37am UTC](https://community.glideapps.com/t/array-column-summary/27007/1 "2021-05-20T09:37:59Z")
Is one able to summerise values in an array column according to their sum? e.g in columns Fruit 1, Fruit 2, Fruit3, Furit 4 & Fruit 5 lets suppose Fruit 2 & Fruit 4 and Fruit 5 are all “Apple”, the array summary should be able to return 3 Apples… Help anyone… ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 20, 2021, 12:58pm UTC](https://community.glideapps.com/t/array-column-summary/27007/2 "2021-05-20T12:58:12Z")
Yes this you should be able to do in the editor without recourse to sheet formulae (loads to choose from). Let me find the thread for you. ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [May 20, 2021, 1:01pm UTC](https://community.glideapps.com/t/array-column-summary/27007/3 "2021-05-20T13:01:58Z")
Many thanks, waiting 😄 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 20, 2021, 3:09pm UTC](https://community.glideapps.com/t/array-column-summary/27007/4 "2021-05-20T15:09:36Z")
Hello sir, I am sorry I could not find any threads on this topic. Stupid me assumed the query was in relation to dynamic filtering of a single column with items bearing the same property. Anyway, here we go. I have done one for you. It’s on tab 4. No sheet formulae or relations. Basically we are splitting the array using ITE & Joinders. We are avoiding everything else. There are so many ways you could achieve this, and I am sure you will be able to build on my example. Thank you ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [May 20, 2021, 3:13pm UTC](https://community.glideapps.com/t/array-column-summary/27007/5 "2021-05-20T15:13:58Z")
an example like this ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/11b2e3399e0f330a710927cd53bf9661f914f507.png) ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 20, 2021, 3:16pm UTC](https://community.glideapps.com/t/array-column-summary/27007/6 "2021-05-20T15:16:06Z")
That’s what I initially assumed until I read “array column”… Check my example. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [May 20, 2021, 3:16pm UTC](https://community.glideapps.com/t/array-column-summary/27007/7 "2021-05-20T15:16:59Z")
Oh oops I watch … ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 20, 2021, 3:17pm UTC](https://community.glideapps.com/t/array-column-summary/27007/8 "2021-05-20T15:17:53Z")
Oops sorry did not add the link…just make a copy. > **[Collapsible accordion](https://flying-can-2202.glideapp.io/)** ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [May 20, 2021, 3:28pm UTC](https://community.glideapps.com/t/array-column-summary/27007/9 "2021-05-20T15:28:00Z")
how many fruit type column there are ? ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 20, 2021, 3:32pm UTC](https://community.glideapps.com/t/array-column-summary/27007/10 "2021-05-20T15:32:45Z")
3 but i used two for the example ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [May 20, 2021, 3:33pm UTC](https://community.glideapps.com/t/array-column-summary/27007/11 "2021-05-20T15:33:08Z")
From simple If / Then between the Search column and Col1, 2, 3, 4, 5 then a calculation of the Total It’s not very beautiful or practical ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46a0aabe2709b9bae0a1f9f0be0395dc0a869f8d.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a9018065f3980cb0065a8a0247931ecb6b80e13.png) ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 20, 2021, 3:34pm UTC](https://community.glideapps.com/t/array-column-summary/27007/12 "2021-05-20T15:34:02Z")
That’s not my example ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [May 20, 2021, 3:35pm UTC](https://community.glideapps.com/t/array-column-summary/27007/13 "2021-05-20T15:35:39Z")
uhmm I was on the question of @Keith_Chikumbirike !!!???!! > Peut-on additionner les valeurs dans une colonne de tableau en fonction de leur somme? > Par exemple, dans les colonnes Fruit 1, Fruit 2, Fruit3, Furit 4 & Fruit 5, supposons que Fruit 2 & Fruit 4 et Fruit 5 sont tous «Apple», le résumé du tableau devrait pouvoir renvoyer 3 pommes… ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 20, 2021, 3:39pm UTC](https://community.glideapps.com/t/array-column-summary/27007/14 "2021-05-20T15:39:24Z")
Oh I see…what you mean. Even my example could be improved on drastically. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [May 20, 2021, 3:40pm UTC](https://community.glideapps.com/t/array-column-summary/27007/15 "2021-05-20T15:40:24Z")
Oh sorry @Wiz.Wazeer I haven’t seen your app link. You’ve done a few good things already. Sorry …