# Sumifs Excel Formula

**URL:** <https://community.glideapps.com/t/sumifs-excel-formula/58174>\
**Category:** Ask for Help\
**Tags:** custom-code\
**Created:** [February 19, 2023, 8:27pm UTC](https://community.glideapps.com/t/sumifs-excel-formula/58174 "2023-02-19T20:27:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [February 19, 2023, 8:27pm UTC](https://community.glideapps.com/t/sumifs-excel-formula/58174/1 "2023-02-19T20:27:57Z")

</div>

Hi Gliders,

I use excel formula for getting an amount of hauling trips from starting date to ending date (see image below). But, such experimental column has no numbers showed. Is there any mistake on my excel formula?

Thanks in advance.

 ![Sumifs Formula](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/932b13a67b48d4874e9f825313287fc5b148521e.jpeg)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 20, 2023, 12:02am UTC](https://community.glideapps.com/t/sumifs-excel-formula/58174/2 "2023-02-20T00:02:19Z")

</div>

I think you can get this with two columns.

- If-Then-Else: If Start is before sn-Start then 0, If Finish is after sn-Finish then 0, else “Trips”.
- Rollup the If-Then-Else column and return the sum.

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [February 20, 2023, 12:12am UTC](https://community.glideapps.com/t/sumifs-excel-formula/58174/3 "2023-02-20T00:12:29Z")

</div>

thanks a lot @ThinhDinh ! 👍 👍

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 18, 2023, 1:14pm UTC](https://community.glideapps.com/t/sumifs-excel-formula/58174/4 "2023-11-18T13:14:53Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.