SUMIFS - between Dates
I am trying to find the total value of products sold with a particular ID in a particular month. I used the formula below to find the value of items with the code reference LSCl30 sold in July 2020. My settings are such that first of July is written 1/7/2020. The result returned is UNPARSEABLE. I tried using 07 but that did not help. Any assistance will be greatly appreciated
=SUMIFS(Net:Net, [Item Code]:[Item Code], "LSCI30",[Invoice Date]:[Invoice Date],<2020, 31, 7), [Invoice Date]:[Invoice Date],>=2020, 1 ,7)
Help Article Resources
Check out the Formula Handbook template!