Summewenn mit Datum

%3CLINGO-SUB%20id%3D%22lingo-sub-1480165%22%20slang%3D%22en-US%22%3ESummewenn%20mit%20Datum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480165%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20i%20use%20the%20sumewenn%20with%20a%20date%20specification.%20I%20would%20like%20to%20link%20sales%20to%20another%20Excel%20list%20every%20month.%20Thank%20you%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1480165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480259%22%20slang%3D%22en-US%22%3ERe%3A%20Summewenn%20mit%20Datum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480259%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706366%22%20target%3D%22_blank%22%3E%40Alexandra1970%3C%2FA%3E%26nbsp%3BPerhaps%20best%20demonstrated%20with%20some%20working%20examples%20(attached).%20For%20multiple%20criteria%2C%20like%20%22SUM%20from%20start%20date%20to%20end%20date%22%2C%20use%20SUMIFS%20or%20a%20combination%20of%20SUM%20and%20FILTER*.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESUMIF%20allows%20on%20one%20criteria%2C%20like%20%22SUM%20from%20date%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20will%20not%20work%20if%20you%20do%20not%20have%20the%20most%20recent%20Excel%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480304%22%20slang%3D%22de-DE%22%3ERe%3A%20Sumif%20with%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480304%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20worked%2C%20thanks%20for%20the%20hint%3A-)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

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

 

 

Highlighted

@Riny_van_Eekelen 

 

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