Forum Discussion

Alexandra1970's avatar
Alexandra1970
Copper Contributor
Jun 22, 2020

Summewenn mit Datum

How do i use the sumewenn with a date specification. I would like to link sales to another Excel list every month. Thank you for your help.

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Alexandra1970 Perhaps best demonstrated with some working examples (attached). For multiple criteria, like "SUM from start date to end date", use SUMIFS or a combination of SUM and FILTER*.

     

    SUMIF allows on one criteria, like "SUM from date"

     

    * will not work if you do not have the most recent Excel version.

     

     

Resources