# Sum of order amount based on the status of completion

**URL:** <https://community.glideapps.com/t/sum-of-order-amount-based-on-the-status-of-completion/77266>\
**Category:** Ask for Help\
**Created:** [October 23, 2024, 8:20am UTC](https://community.glideapps.com/t/sum-of-order-amount-based-on-the-status-of-completion/77266 "2024-10-23T08:20:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Teentaal\_l](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teentaal_l/32/32745_2.png) [@Teentaal\_l](https://community.glideapps.com/u/Teentaal_l)\
**Post date:** [October 23, 2024, 8:20am UTC](https://community.glideapps.com/t/sum-of-order-amount-based-on-the-status-of-completion/77266/1 "2024-10-23T08:20:13Z")

</div>

I have built an app for a food business, they take orders and they want a simple list of all the orders for which the status of the order is complete in an invoice. The problem is I an able rollup the amount based on the Status - Completed but not able to exclude Pending status create a total. Please help.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 23, 2024, 8:26am UTC](https://community.glideapps.com/t/sum-of-order-amount-based-on-the-status-of-completion/77266/2 "2024-10-23T08:26:07Z")

</div>

Use a Query column with appropriate filters to match the orders that you want, then do a rollup through the query column.