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…
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.
Many thanks, waiting 
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
an example like this
That’s what I initially assumed until I read “array column”… Check my example.
Oh oops
I watch …
Oops sorry did not add the link…just make a copy.
how many fruit type column there are ?
3 but i used two for the example
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
That’s not my example
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…
Oh I see…what you mean. Even my example could be improved on drastically.
Oh sorry @Wiz.Wazeer
I haven’t seen your app link.
You’ve done a few good things already.
Sorry …
