# Creating a SumIf

**URL:** <https://community.glideapps.com/t/creating-a-sumif/69107>\
**Category:** Ask for Help\
**Created:** [December 30, 2023, 3:20am UTC](https://community.glideapps.com/t/creating-a-sumif/69107 "2023-12-30T03:20:56Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 30, 2023, 4:15am UTC](https://community.glideapps.com/t/creating-a-sumif/69107/3 "2023-12-30T04:15:16Z")

</div>

> [@Generating a total](https://community.glideapps.com/t/generating-a-total/69100/2):
>
> You can use a Rollup column to create totals. If you want to Rollup filtered data, then you can also apply a Rollup column to an existing relation or query instead of an entire table. When trying to Rollup a value for a specific month, it’s best to use a math column to convert any dates into an easy numeric value. This in a math column will give you the year and month joined together. Year(Date)\*10^2 +Month(Date) Then you can use that number to create relations.

---

_[View the full topic](https://community.glideapps.com/t/creating-a-sumif/69107)._