# Sum from a Select List objects **URL:** \ **Category:** Ask the Community\ **Created:** [August 20, 2021, 8:54am UTC](https://connect.superhuman.com/t/sum-from-a-select-list-objects/25142 "2021-08-20T08:54:25Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Caracole](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@Caracole](https://connect.superhuman.com/u/Caracole)\ **Post date:** [August 20, 2021, 8:54am UTC](https://connect.superhuman.com/t/sum-from-a-select-list-objects/25142/1 "2021-08-20T08:54:25Z")
Hi everyone, I’m not sure if this is a bug or a formula I’m writing wrong, but here is my issue: In the last table, I would like to summarize the amount of fruits the Person 1 chose during the week, depending on the Basket. So, in the last table, for Basket A (row 1), I get “4” as expected (2x Apple + 2x Cherry). For Basket C (row 3), I get “3” as expected (2x Apple + 1x Peer). But, for Basket B (row 2), I get only “1” instead of 2 as I would expect. It seems my formula doesn’t like the fact that Banana and Melon are in the same cell in Table 2. Here is my formula: ![Coda_Formula_Issue](https://global.discourse-cdn.com/coda1/original/3X/6/5/653638ff1de7b35108aa8e57fe751a9fc4b6eae5.png) Thanks a lot for your help and have a nice day. ---
**Author:** ![Nick\_HE](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/nick_he/32/6190_2.png) [@Nick\_HE](https://connect.superhuman.com/u/Nick_HE)\ **Post date:** [August 20, 2021, 3:52pm UTC](https://connect.superhuman.com/t/sum-from-a-select-list-objects/25142/2 "2021-08-20T15:52:24Z")
Could you share a copy of the doc publicly? ---
**Author:** ![Caracole](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@Caracole](https://connect.superhuman.com/u/Caracole)\ **Post date:** [August 20, 2021, 4:08pm UTC](https://connect.superhuman.com/t/sum-from-a-select-list-objects/25142/3 "2021-08-20T16:08:12Z")
Hi Nick, Sure, here it is, thanks. https://coda.io/embed/JuC-jakRty?viewMode=embed ---
**Author:** ![Ryan\_Martens2](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ryan_martens2/32/19566_2.png) [@Ryan\_Martens2](https://connect.superhuman.com/u/Ryan_Martens2)\ **Post date:** [August 21, 2021, 7:28am UTC](https://connect.superhuman.com/t/sum-from-a-select-list-objects/25142/4 "2021-08-21T07:28:02Z")
Hi @Caracole, I’m still not entirely clear on exactly what you are trying to do, but I would recommend a bit of a change in schema. Specifically, a table of people (assuming there will be more than just “Person 1” in there eventually), and the last table actually seems like it should be just a view of the “Baskets” table. See the page I added in your shared doc: https://coda.io/embed/JuC-jakRty/_suObS?viewMode=embedplay I think I got the formula you want (in the column labelled **Person 1** ), but I’m really not sure why you want this number. How is this going to be used? ---
**Author:** ![Caracole](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@Caracole](https://connect.superhuman.com/u/Caracole)\ **Post date:** [August 23, 2021, 12:42pm UTC](https://connect.superhuman.com/t/sum-from-a-select-list-objects/25142/5 "2021-08-23T12:42:08Z")
Hi Ryan, Thanks for your help. Actually, someone updated the Table on Page 2. The information I wanted to have was: which basket best suits the habits of the people according to the composition of the baskets and according to their daily consumption habits (“Fruits - People’s taste per Basket 2” table). Thanks to it, I know that Basket A & C feats better the Person 1 than the Basket B, and so. Thanks a lot for your help. ---
**Author:** ![Ryan\_Martens2](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ryan_martens2/32/19566_2.png) [@Ryan\_Martens2](https://connect.superhuman.com/u/Ryan_Martens2)\ **Post date:** [August 29, 2021, 6:33am UTC](https://connect.superhuman.com/t/sum-from-a-select-list-objects/25142/6 "2021-08-29T06:33:01Z")
Ah ok, that makes sense. You are finding the best basket-person matches. Now I see why you had the extra table at the end — that was actually smart considering the complexity of the task (assuming you will have many more than three people and three baskets). It might be overkill at this point, but I updated the page I made in your doc with an additional table and better formulas. ---
**Author:** ![Caracole](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@Caracole](https://connect.superhuman.com/u/Caracole)\ **Post date:** [September 3, 2021, 9:19am UTC](https://connect.superhuman.com/t/sum-from-a-select-list-objects/25142/7 "2021-09-03T09:19:58Z")
That’s great, thanks for adding these tables.