# How to get sum based on many criteria
**URL:** https://community.glideapps.com/t/how-to-get-sum-based-on-many-criteria/28422
**Category:** Ask for Help
**Created:** [June 27, 2021, 6:20pm UTC](https://community.glideapps.com/t/how-to-get-sum-based-on-many-criteria/28422 "2021-06-27T18:20:04Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)
#### Post date: [June 27, 2021, 6:20pm UTC](https://community.glideapps.com/t/how-to-get-sum-based-on-many-criteria/28422/1 "2021-06-27T18:20:04Z")
Hi,
Hope u r doing well. Here I’ve shared a screenshot.
Let Tom be staff.
I need to get his total conveyance, total OT & total HD for specific month.
Thanks in Advance.
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [June 27, 2021, 6:26pm UTC](https://community.glideapps.com/t/how-to-get-sum-based-on-many-criteria/28422/2 "2021-06-27T18:26:32Z")
Here’s what I would do:
1. Get the month and year as separate columns (can be done using a Math column, or in Sheets, your preference). Edit: just saw that you already have the month column; adding the year column will ensure you can get appropriate results next year too!
2. Create a template to combines the user’s name (or better yet, a more unique identifier for the User that won’t change), the month and year. (Example result: [email@email.com](mailto:email@email.com) April 2021)
3. Create a multiple relation of the template column to itself.
4. Create Rollup columns to get the sum of each column you need to calculate.
---
### Author:  [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)
#### Post date: [June 28, 2021, 7:48am UTC](https://community.glideapps.com/t/how-to-get-sum-based-on-many-criteria/28422/3 "2021-06-28T07:48:03Z")
Its working. Thanks, Buddy.