# Calculating the total of only certain amounts within a table

**URL:** <https://community.glideapps.com/t/calculating-the-total-of-only-certain-amounts-within-a-table/31260>\
**Category:** Ask for Help\
**Created:** [September 2, 2021, 8:02am UTC](https://community.glideapps.com/t/calculating-the-total-of-only-certain-amounts-within-a-table/31260 "2021-09-02T08:02:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Suvone](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/suvone/32/25662_2.png) [@Suvone](https://community.glideapps.com/u/Suvone)\
**Post date:** [September 2, 2021, 8:02am UTC](https://community.glideapps.com/t/calculating-the-total-of-only-certain-amounts-within-a-table/31260/1 "2021-09-02T08:02:07Z")

</div>

I’m busy with a budget app and for our needs (and the easiest automation) it will require me to copy paste the bank statement into the Google Sheet. I would like to make it a continuous thing, so at the end of every month I will just add on. I want to avoid making a new sheet for every month. That will be my last resort…

So, now I would like to do a calculation for the income and expenses per month. At this stage the roll up function works well to calculate everything together but I want to see the totals per month.  
I have a separate column that lists the exact month and year that the transaction took place, “July 2021”.  
Is there any way that I can use the Month\_Year column to calculate the values for that month only?

Or will I have to make separate sheets for every month?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 2, 2021, 8:10am UTC](https://community.glideapps.com/t/calculating-the-total-of-only-certain-amounts-within-a-table/31260/2 "2021-09-02T08:10:49Z")

</div>

@Suvone make a USC column (if more than 1 user), to enter the month and year…create a template column and add a space to a date column (that will change this column a text), then if-else column to extract amounts that month and year are included in the date, then a rollup column to sum it

---

<div class="post-metadata">

**Author:** ![Suvone](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/suvone/32/25662_2.png) [@Suvone](https://community.glideapps.com/u/Suvone)\
**Post date:** [September 2, 2021, 8:19am UTC](https://community.glideapps.com/t/calculating-the-total-of-only-certain-amounts-within-a-table/31260/3 "2021-09-02T08:19:38Z")

</div>

That is simple enough. I would then have to do that for every month separately?  
I would make a if-then for July, then a roll up  
Then a if-then for Augusts, and a roll up, and so on  
Do I understand that correctly?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 2, 2021, 8:21am UTC](https://community.glideapps.com/t/calculating-the-total-of-only-certain-amounts-within-a-table/31260/4 "2021-09-02T08:21:12Z")

</div>

no, it will change automatically, depend on the month and year you will enter… you can make a choice list of months… so you don’t need to enter manually… unless you want to have permanent data of each month separately… then yes… do separate sheets

---

<div class="post-metadata">

**Author:** ![Suvone](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/suvone/32/25662_2.png) [@Suvone](https://community.glideapps.com/u/Suvone)\
**Post date:** [September 2, 2021, 8:24am UTC](https://community.glideapps.com/t/calculating-the-total-of-only-certain-amounts-within-a-table/31260/5 "2021-09-02T08:24:53Z")

</div>

Thank you very much for the help! I know what to do know.