1. Home
  2. Knowledge Base
  3. Microsoft
  4. Excel
  5. Sumwenns with TODAY() as condition

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)

Was this article helpful?

Related Articles

Submit a Comment

Your email address will not be published. Required fields are marked *

Published on - 17. Apr 2021
Modified on - 29. Mar 2024
Views - 41
Likes - 0

Do you need help?

Kontaktiere uns gerne :-)
Contact Support
Skip to content