# HOW TO? conditional summarize formula

**URL:** <https://connect.superhuman.com/t/how-to-conditional-summarize-formula/23339>\
**Category:** Ask the Community\
**Created:** [May 10, 2021, 9:34am UTC](https://connect.superhuman.com/t/how-to-conditional-summarize-formula/23339 "2021-05-10T09:34:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Konsztantinosz\_Dulasz](https://avatars.discourse-cdn.com/v4/letter/k/c2a13f/32.png) [@Konsztantinosz\_Dulasz](https://connect.superhuman.com/u/Konsztantinosz_Dulasz)\
**Post date:** [May 10, 2021, 9:34am UTC](https://connect.superhuman.com/t/how-to-conditional-summarize-formula/23339/1 "2021-05-10T09:34:17Z")

</div>

hello dearest ppl 🙂

please help me if you can! 🙏🏻

I have a table with a lot of data.

its invoices with dates, ammounts, project numbers, project categories and others

the rows (datas) I paste from an external export file

I want to make a conditional summary… but I cant make it work

I know the table views, but in this case I want to summarizeon different conditions with a fuction

I want to summarize the ammounts of a table collumn, but only then if eg. the project number is “140” AND project category is “organizational costs”

I used the sumif but it gives me a 0 🙁

---

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [May 10, 2021, 9:52am UTC](https://connect.superhuman.com/t/how-to-conditional-summarize-formula/23339/2 "2021-05-10T09:52:47Z")

</div>

Hi @Konsztantinosz_Dulasz ,  
and welcome to Coda Community! 🤝

Would it be possible to share your document (or a sample of it) with your expected outcomes?  
This way it would be easier to dig into and give a proper solution.

Thank you!

---

<div class="post-metadata">

**Author:** ![Konsztantinosz\_Dulasz](https://avatars.discourse-cdn.com/v4/letter/k/c2a13f/32.png) [@Konsztantinosz\_Dulasz](https://connect.superhuman.com/u/Konsztantinosz_Dulasz)\
**Post date:** [May 10, 2021, 10:58am UTC](https://connect.superhuman.com/t/how-to-conditional-summarize-formula/23339/3 "2021-05-10T10:58:32Z")

</div>

hi @Federico_Stefanato  
thanks 🙂  
here is the link:  
https://coda.io/embed/b_oGqKn2vA?viewMode=embed

---

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [May 10, 2021, 11:15am UTC](https://connect.superhuman.com/t/how-to-conditional-summarize-formula/23339/4 "2021-05-10T11:15:36Z")

</div>

OK, @Konsztantinosz_Dulasz , I think I got your point.

I already provided the formula in your doc, but perhaps it worth explaining a bit:

```auto
[Table 1].Filter([Termék, szolgáltatás]=150).[Tétel bruttó érték].Sum()

```

In plain english:  
“_Please, give me the sum of `Tétel bruttó érték` column for all the rows that have `Termék, szolgáltatás` = 150_”

Why **`SumIf()`** is not working?  
E.g.

```auto
SumIf([Table 1].[Tétel bruttó érték],[Termék, szolgáltatás]=150)

```

or the equivalent, which helps to better understand:

```auto
[Table 1].[Tétel bruttó érték].SumIf([Table 1].[Termék, szolgáltatás]=150)

```

The _context_ of the formula is the last element you are referring to and the condition is bound to it.  
So, the “ **If** ” of the **`SumIf()`** is evaluating the condition over the iterating element (the `[Tétel bruttó érték]` column.

It would work if you ask something like:

```auto
[Table 1].[Tétel bruttó érték].SumIf(currentValue >10)

```

I hope this clarifies a little bit.  
Let me know otherwise.

Cheers!

---

<div class="post-metadata">

**Author:** ![Konsztantinosz\_Dulasz](https://avatars.discourse-cdn.com/v4/letter/k/c2a13f/32.png) [@Konsztantinosz\_Dulasz](https://connect.superhuman.com/u/Konsztantinosz_Dulasz)\
**Post date:** [May 10, 2021, 11:37am UTC](https://connect.superhuman.com/t/how-to-conditional-summarize-formula/23339/5 "2021-05-10T11:37:48Z")

</div>

thanks a lot!!! 🙏

i am still thinking toooo excellish 😅

---

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [May 10, 2021, 12:25pm UTC](https://connect.superhuman.com/t/how-to-conditional-summarize-formula/23339/6 "2021-05-10T12:25:13Z")

</div>

> [@Konsztantinosz\_Dulasz](#):
>
> i am still thinking toooo excellish 😅

Which is good: never loose that experience. 😉

Anyway, you’ll see you will get familiar with Coda really quickly!