Forum Discussion
Alexandra1970
Jun 22, 2020Copper Contributor
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.
Riny_van_Eekelen
Jun 22, 2020Platinum 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.
Alexandra1970
Jun 22, 2020Copper Contributor