SUMIFS and advanced formulas

[gvalero]

Hola,

there is a plan C if you want to go beyond to Jeff’s suggestion: JavaScript code

I know it’s not a “no code solution” but sometimes, not all can be “no code”

Here my example: Imagine you want to have all values with Date=“2021-Q1” and “Expired=True”, your table could look like this

1. your JS code might be this, something short and able to save columns
   

   

2. Later, we need to convert this result (text) to a numeric value using a Math column and get the Total (sum) by using a Rollup column.
   

   

But let’s complicate the case!
Imagine now we want to have the Total (Sum) associated to all Q1s no matter the year (2019/2020/2021-Q1) with “Expired=True”, so the JS code would be:

if ((p1=="2019-Q1" || p1=="2020-Q1" ||  p1=="2021-Q1") && p2==true)
   return p3

and after converting the above result to a numeric value and use a rollup to sum values, your table will look like this:

I hope it helps.

Saludos!