# Roll-up with conditions
**URL:** https://community.glideapps.com/t/roll-up-with-conditions/5945
**Category:** Feature Requests
**Created:** [March 27, 2020, 11:07am UTC](https://community.glideapps.com/t/roll-up-with-conditions/5945 "2020-03-27T11:07:02Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)
#### Post date: [March 27, 2020, 11:07am UTC](https://community.glideapps.com/t/roll-up-with-conditions/5945/1 "2020-03-27T11:07:02Z")
I would like a sort of sumifs
For instance roll-up values if date is Today and code is Cod1
Sumifs in arrayformula do not work ok.
Any walkarround?? Thanks
Take care!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 27, 2020, 12:51pm UTC](https://community.glideapps.com/t/roll-up-with-conditions/5945/2 "2020-03-27T12:51:49Z")
As long as you aren’t trying to do a range of values (\>= \<=), and you are only looking for equal values, then you can use a SUMIF and Join the values together. So you would join Today() & ‘Cod1’ as one value to compare to the same joined value. With something simple like that, you could probably use templates relations and rollups to do the same thing without a sheet formula.
Edit: Sorry for my inability to spell anything correctly. I fixed a couple of mistakes above.
---
### Author:  [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)
#### Post date: [March 27, 2020, 6:01pm UTC](https://community.glideapps.com/t/roll-up-with-conditions/5945/3 "2020-03-27T18:01:40Z")
Thanks Jeff. Testing…
---
### Author:  [@Food2Soil](https://community.glideapps.com/u/Food2Soil)
#### Post date: [August 22, 2020, 9:35pm UTC](https://community.glideapps.com/t/roll-up-with-conditions/5945/4 "2020-08-22T21:35:14Z")
How would I get the result above if I was trying to sum up the sales per individual? using sumif and arrayformula adds too many extra rows in the sheet. So it would be great if I could use Rollup with a condition.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 22, 2020, 9:40pm UTC](https://community.glideapps.com/t/roll-up-with-conditions/5945/5 "2020-08-22T21:40:06Z")
Create a relation from the user to the user’s sales then Rollup the relation.
---
### Author:  [@Food2Soil](https://community.glideapps.com/u/Food2Soil)
#### Post date: [August 22, 2020, 9:41pm UTC](https://community.glideapps.com/t/roll-up-with-conditions/5945/6 "2020-08-22T21:41:50Z")
Thankyou!