Jun 22 2020 12:25 AM
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.
Jun 22 2020 01:24 AM
@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.
Jun 22 2020 01:55 AM