Sumwenns with TODAY() as condition

If you want to form a sum with values where the due date has passed, this notation from Summewenns can help:

=SUMMEWENNS(Table1[Restbetrag];Table1[Fälligkeitsdatum];"<="&HEUTE())

In this example, the remaining amount that is already overdue or due today is totaled.

Dieser Beitrag ist auch verfügbar auf: Deutsch (German)