# Sum filtered from another table

**URL:** <https://connect.superhuman.com/t/sum-filtered-from-another-table/15837>\
**Category:** Ask the Community\
**Created:** [May 11, 2020, 10:07am UTC](https://connect.superhuman.com/t/sum-filtered-from-another-table/15837 "2020-05-11T10:07:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eric\_Munier](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/eric_munier/32/6249_2.png) [@Eric\_Munier](https://connect.superhuman.com/u/Eric_Munier)\
**Post date:** [May 11, 2020, 10:07am UTC](https://connect.superhuman.com/t/sum-filtered-from-another-table/15837/1 "2020-05-11T10:07:26Z")

</div>

Hello community,

I am basically trying to filter a list. This seems easy but i’m clearly missing a point somewhere.

I have a table of **orders** referencing a **client** and listing a **price** for the order.  
I have a table of **clients** where I want to have the total of all orders per clients and the number of orders per clients.  
And there is something wrong with my filter formula for the total per client.  
My count formula is working though. So I thought I understood the syntax…

Any help will be greatly appreciated.  
Thanks

https://coda.io/embed/NfRAn_RRrA/_suKWW?viewMode=embedplay

---

<div class="post-metadata">

**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\
**Post date:** [May 11, 2020, 10:41am UTC](https://connect.superhuman.com/t/sum-filtered-from-another-table/15837/2 "2020-05-11T10:41:43Z")

</div>

Dear @Eric_Munier,

The syntax is as below, the first to count the orders and the second the total amount of the orders

```
Orders.filter(Client=thisRow).Order.count() 

Orders.Filter(Client=thisRow).Price.Sum()

```

**The way Coda works is:**

Look in the table [orders] filter the (Client=thisRow) and then in case of:

the order; count how many orders there have been made.

the price, give the sum for all amounts under “Price”

 ![image](https://global.discourse-cdn.com/coda1/original/2X/c/c6f0f2145074bf30e0123f3345333c799efbdf17.png)  
 ![image](https://global.discourse-cdn.com/coda1/original/2X/a/a0c3ff4b584585a41a2ea0830cfdec288295064f.png)

---

<div class="post-metadata">

**Author:** ![Eric\_Munier](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/eric_munier/32/6249_2.png) [@Eric\_Munier](https://connect.superhuman.com/u/Eric_Munier)\
**Post date:** [May 11, 2020, 10:59am UTC](https://connect.superhuman.com/t/sum-filtered-from-another-table/15837/3 "2020-05-11T10:59:30Z")

</div>

so simple.  
Thanks so much @Jean_Pierre_Traets