# Excel SUMIFS equivalent in Parabola

**URL:** <https://community.parabola.io/t/excel-sumifs-equivalent-in-parabola/2919>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [April 5, 2024, 7:47pm UTC](https://community.parabola.io/t/excel-sumifs-equivalent-in-parabola/2919 "2024-04-05T19:47:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ethan\_Grossman](https://avatars.discourse-cdn.com/v4/letter/e/45deac/32.png) [@Ethan\_Grossman](https://community.parabola.io/u/Ethan_Grossman)\
**Post date:** [April 5, 2024, 7:47pm UTC](https://community.parabola.io/t/excel-sumifs-equivalent-in-parabola/2919/1 "2024-04-05T19:47:32Z")

</div>

I know this would be done in Excel using SUMIFS, but I’m trying to use Parabola. I see there’s a SUM function, but I need a SUMIFS function which can provide me the SUM based on 4 criteria - how can this be accomplished?

Table 1:

- Has cost information for specific airline flights
- The 4 relevant criteria are (1) Flight Departure Date (2) Flight Number (3) Origin & Destination and (4) Cabin Class
- The combination of these 4 relevant criteria results in a unique airline flight that is not repeated

Table 2:

- Include flight data for a specific demographic
- This table also includes the 4 relevant criteria listed above (Flight Departure Date, Flight Number, Origin & Destination, Cabin Cass)
- I want to pull in the cost information from Table 1 into Table 2, only if the 4 relevant criteria match

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [April 5, 2024, 8:45pm UTC](https://community.parabola.io/t/excel-sumifs-equivalent-in-parabola/2919/2 "2024-04-05T20:45:05Z")

</div>

Hi @Ethan_Grossman

Try using a Combine tables step and connect each table as an input to that step. Keep `only matching rows` from Table 2 and `only matching rows` from Table 1.

Next, configure the step to combine data where `all` columns match.

You can then add 4 rules matching the Flight Departure Date column from Table 2 to the same column in Table 1. Do the same for Flight Number, Origin & Destination, and Cabin class.

Your new table will only display records where a match has been found amongst your criteria. Finally, use a Sum by group step to sum your values.

Let me know if this helps!

---

<div class="post-metadata">

**Author:** ![Ethan\_Grossman](https://avatars.discourse-cdn.com/v4/letter/e/45deac/32.png) [@Ethan\_Grossman](https://community.parabola.io/u/Ethan_Grossman)\
**Post date:** [April 5, 2024, 9:15pm UTC](https://community.parabola.io/t/excel-sumifs-equivalent-in-parabola/2919/3 "2024-04-05T21:15:25Z")

</div>

Thanks @daniel ! That was great - exactly the direction I needed to build out the rest of the flow.