unfortunately I already tried SumIf and Filter but something seems to be missing.

For example when I try the following formulas, it searches in the “Stage” column if there is a “planed” somewhere, and if so, it sums up the whole column “Holidays” and gives me 26 as result. But I expect as result 13 because only these Holidays are in Stage “planed” …

a) t_urlaubs_planung.Holidays.SumIf(t_urlaubs_planung.Stage.Contains(planed))

b) t_urlaubs_planung.Holidays.SumIf(t_urlaubs_planung.Stage.Filter(planed))

Any idea what the right formula is to get this working?