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