Summewenn mit Datum

Copper Contributor

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

@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.

 

 

@Riny_van_Eekelen 

 

es hat funktioniert, vielen Dank für den Hinweis:-)