Roll-up with conditions

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!

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.

1 Like

Thanks Jeff. Testing…

1 Like

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.

Create a relation from the user to the user’s sales then Rollup the relation.

1 Like