念念念念 发表于 2024-1-18 09:03

求大佬帮忙!想统计近30天每个型号的销售数据

想根据sheet1中A列型号,求sheet2中该型号近30天的销量,求大佬给个公式,万分感谢

表格在附件中

hugeinfo 发表于 2024-1-18 09:19

=SUMIFS(Sheet2!C:C,Sheet2!B:B,A2,Sheet2!A:A,"<="&TODAY(),Sheet2!A:A,">="&TODAY()-30)

念念念念 发表于 2024-1-18 09:35

hugeinfo 发表于 2024-1-18 09:19
=SUMIFS(Sheet2!C:C,Sheet2!B:B,A2,Sheet2!A:A,"="&TODAY()-30)

不好使啊。大佬,我就是这样的公式。输出结果是0

念念念念 发表于 2024-1-18 09:38

hugeinfo 发表于 2024-1-18 09:19
=SUMIFS(Sheet2!C:C,Sheet2!B:B,A2,Sheet2!A:A,"="&TODAY()-30)

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVoAAACSCAYAAAAEnQIbAAAMP2lDQ1BJQ0MgUHJvZmlsZQAASImVVwdYU8kWnluSkEBooUsJvQkCUgJICaEFkF4EUQlJgFBiDAQVe1lUcC2oiIINXRVR7DQLithZFHtfLCgo62LBrrxJAV33le+d75t7//vPmf+cOXduGQDUTnBEolxUHYA8YYE4NiSAPi45hU7qAQhQB1RAAs4cbr6IGR0dAaANnf9u725Ab2hXHaRa/+z/r6bB4+dzAUCiIU7n5XPzID4EAF7FFYkLACBKefOpBSIphg1oiWGCEC+W4kw5rpLidDneJ/OJj2VB3AaAkgqHI84EQPUy5OmF3EyoodoPsZOQJxACoEaH2DcvbzIP4jSIbaCPCGKpPiP9B53Mv2mmD2tyOJnDWD4XmSkFCvJFuZzp/2c5/rfl5UqGYljBppIlDo2VzhnW7VbO5HApVoG4T5geGQWxJsQfBDyZP8QoJUsSmiD3Rw25+SxYM6ADsROPExgOsSHEwcLcyAgFn54hCGZDDFcIOk1QwI6HWA/ixfz8oDiFz2bx5FhFLLQ+Q8xiKvhzHLEsrjTWA0lOAlOh/zqLz1boY6pFWfFJEFMgtigUJEZCrAqxY35OXLjCZ0xRFityyEcsiZXmbwFxLF8YEiDXxwozxMGxCv+SvPyh+WKbswTsSAU+UJAVHyqvD9bG5cjyh3PBLvOFzIQhHX7+uIihufD4gUHyuWM9fGFCnELng6ggIFY+FqeIcqMV/rgZPzdEyptB7JpfGKcYiycWwAUp18czRAXR8fI88aJsTli0PB98BYgALBAI6EACWzqYDLKBoKOvoQ9eyXuCAQeIQSbgAwcFMzQiSdYjhMc4UAT+hIgP8ofHBch6+aAQ8l+HWfnRAWTIegtlI3LAU4jzQDjIhdcS2SjhcLRE8AQygn9E58DGhfnmwibt//f8EPudYUImQsFIhiLS1YY8iUHEQGIoMZhoixvgvrg3HgGP/rC54Azcc2ge3/0JTwmdhEeE64Quwu1Jgvnin7IcC7qgfrCiFuk/1gK3gppueADuA9WhMq6DGwAH3BXGYeJ+MLIbZFmKvKVVof+k/bcZ/HA3FH5kJzJK1iX7k21+Hqlqp+o2rCKt9Y/1keeaPlxv1nDPz/FZP1SfB8/hP3tii7GD2FnsJHYeO4o1ADrWgjVi7dgxKR5eXU9kq2soWqwsnxyoI/hHvKE7K61kvlOtU6/TF3lfAX+a9B0NWJNF08WCzKwCOhN+Efh0tpDrOJLu4uTiCoD0+yJ/fb2JkX03EJ3279yCPwDwaRkcHDzynQtrAWC/B3z8m75zNgz46VAG4FwTVyIulHO49ECAbwk1+KTpA2NgDmzgfFyAO/AG/iAIhIEoEA+SwUSYfRZc52IwFcwE80AxKAUrwBqwHmwCW8FOsAccAA3gKDgJzoCL4DK4Du7C1dMNXoB+8A58RhCEhFARGqKPmCCWiD3igjAQXyQIiUBikWQkDclEhIgEmYksQEqRMmQ9sgWpQfYjTchJ5DzSidxGHiK9yGvkE4qhKqgWaoRaoaNQBspEw9F4dAKaiU5Bi9CF6DK0Aq1Gd6P16En0Inod7UJfoAMYwJQxHcwUc8AYGAuLwlKwDEyMzcZKsHKsGqvDmuF9vop1YX3YR5yI03A67gBXcCiegHPxKfhsfCm+Ht+J1+Nt+FX8Id6PfyNQCYYEe4IXgU0YR8gkTCUUE8oJ2wmHCafhs9RNeEckEnWI1kQP+CwmE7OJM4hLiRuIe4kniJ3Ex8QBEomkT7In+ZCiSBxSAamYtI60m9RCukLqJn1QUlYyUXJRClZKURIqzVcqV9qldFzpitIzpc9kdbIl2YscReaRp5OXk7eRm8mXyN3kzxQNijXFhxJPyabMo1RQ6iinKfcob5SVlc2UPZVjlAXKc5UrlPcpn1N+qPxRRVPFToWlkqoiUVmmskPlhMptlTdUKtWK6k9NoRZQl1FrqKeoD6gfVGmqjqpsVZ7qHNVK1XrVK6ov1chqlmpMtYlqRWrlagfVLqn1qZPVrdRZ6hz12eqV6k3qN9UHNGgazhpRGnkaSzV2aZzX6NEkaVppBmnyNBdqbtU8pfmYhtHMaSwal7aAto12mtatRdSy1mJrZWuVau3R6tDq19bUdtVO1J6mXal9TLtLB9Ox0mHr5Oos1zmgc0Pnk66RLlOXr7tEt073iu57vRF6/np8vRK9vXrX9T7p0/WD9HP0V+o36N83wA3sDGIMphpsNDht0DdCa4T3CO6IkhEHRtwxRA3tDGMNZxhuNWw3HDAyNgoxEhmtMzpl1GesY+xvnG282vi4ca8JzcTXRGCy2qTF5Dldm86k59Ir6G30flND01BTiekW0w7Tz2bWZglm8832mt03p5gzzDPMV5u3mvdbmFiMtZhpUWtxx5JsybDMslxredbyvZW1VZLVIqsGqx5rPWu2dZF1rfU9G6qNn80Um2qba7ZEW4Ztju0G28t2qJ2bXZZdpd0le9Te3V5gv8G+cyRhpOdI4cjqkTcdVByYDoUOtQ4PHXUcIxznOzY4vhxlMSpl1MpRZ0d9c3JzynXa5nTXWdM5zHm+c7Pzaxc7F65Lpcu10dTRwaPnjG4c/crV3pXvutH1lhvNbazbIrdWt6/uHu5i9zr3Xg8LjzSPKo+bDC1GNGMp45wnwTPAc47nUc+PXu5eBV4HvP7ydvDO8d7l3TPGegx/zLYxj33MfDg+W3y6fOm+ab6bfbv8TP04ftV+j/zN/Xn+2/2fMW2Z2czdzJcBTgHigMMB71lerFmsE4FYYEhgSWBHkGZQQtD6oAfBZsGZwbXB/SFuITNCToQSQsNDV4beZBuxuewadn+YR9issLZwlfC48PXhjyLsIsQRzWPRsWFjV429F2kZKYxsiAJR7KhVUfejraOnRB+JIcZEx1TGPI11jp0ZezaOFjcpblfcu/iA+OXxdxNsEiQJrYlqiamJNYnvkwKTypK6xo0aN2vcxWSDZEFyYwopJTFle8rA+KDxa8Z3p7qlFqfemGA9YdqE8xMNJuZOPDZJbRJn0sE0QlpS2q60L5woTjVnIJ2dXpXez2Vx13Jf8Px5q3m9fB9+Gf9Zhk9GWUZPpk/mqszeLL+s8qw+AUuwXvAqOzR7U/b7nKicHTmDuUm5e/OU8tLymoSawhxh22TjydMmd4rsRcWirileU9ZM6ReHi7fnI/kT8hsLtOCPfLvERvKL5GGhb2Fl4YepiVMPTtOYJpzWPt1u+pLpz4qCi36bgc/gzmidaTpz3syHs5iztsxGZqfPbp1jPmfhnO65IXN3zqPMy5n3+3yn+WXz3y5IWtC80Gjh3IWPfwn5pbZYtVhcfHOR96JNi/HFgsUdS0YvWbfkWwmv5EKpU2l56Zel3KUXfnX+teLXwWUZyzqWuy/fuIK4Qrjixkq/lTvLNMqKyh6vGruqfjV9dcnqt2smrTlf7lq+aS1lrWRtV0VEReM6i3Ur1n1Zn7X+emVA5d4qw6olVe838DZc2ei/sW6T0abSTZ82Czbf2hKypb7aqrp8K3Fr4dan2xK3nf2N8VvNdoPtpdu/7hDu6NoZu7OtxqOmZpfhruW1aK2ktnd36u7LewL3NNY51G3Zq7O3dB/YJ9n3fH/a/hsHwg+0HmQcrDtkeajqMO1wST1SP72+vyGroasxubGzKayptdm7+fARxyM7jpoerTymfWz5ccrxhccHW4paBk6ITvSdzDz5uHVS691T405da4tp6zgdfvrcmeAzp84yz7ac8zl39LzX+aYLjAsNF90v1re7tR/+3e33wx3uHfWXPC41Xva83Nw5pvP4Fb8rJ68GXj1zjX3t4vXI6503Em7cupl6s+sW71bP7dzbr+4U3vl8d+49wr2S++r3yx8YPqj+w/aPvV3uXcceBj5sfxT36O5j7uMXT/KffOle+JT6tPyZybOaHpeeo73BvZefj3/e/UL04nNf8Z8af1a9tHl56C//v9r7x/V3vxK/Gny99I3+mx1vXd+2DkQPPHiX9+7z+5IP+h92fmR8PPsp6dOzz1O/kL5UfLX92vwt/Nu9wbzBQRFHzJH9CmCwoRkZALzeAQA1GQAa3J9Rxsv3fzJD5HtWGQL/Ccv3iDJzB6AO/r/H9MG/m5sA7NsGt19QXy0VgGgqAPGeAB09ergN7dVk+0qpEeE+YHPs1/S8dPBvTL7n/CHvn89AquoKfj7/C8z5fGSstgyDAAAAbGVYSWZNTQAqAAAACAAEARoABQAAAAEAAAA+ARsABQAAAAEAAABGASgAAwAAAAEAAgAAh2kABAAAAAEAAABOAAAAAAAAAJAAAAABAAAAkAAAAAEAAqACAAQAAAABAAABWqADAAQAAAABAAAAkgAAAAAVYXdKAAAACXBIWXMAABYlAAAWJQFJUiTwAAA6BUlEQVR4Ae1dB5gURRMt8Mg5HRmOKBJPMkgGyUkBEVAQRIIYMKAiP0EJigFQEJAsiJIFyUjOOeec4cg5w/79eum9mdmZDbe7x95RxbfMTOd5e1tT/aq6J86VK1ds5EYuXbpEt2/fpqxZs1LcuHHdlOZsfyMwZcoUWrZsGSVOnJj69etHPXr0oBs3blD58uWpefPm/u4uRrV3+fLlGDXeZzHYWv/8SCduXKIKmfPR8GqtXQ5h7dlD1Pa/UbJMv1eaUMPcxV2Wf14z06RJ49Wtu9Waq1atopEjR9Jff/0lP0+ePPGqAy7sGwIPHz6kDRs2yEZKlChBCRIkoFKlSsnrTZs20YMHD3zrgGszAhoEEoXE01zxqb8QcKloly9fTqtXr3b0derUKTp//rzjmk8Cj8D27dvpzp07sqOyZcvKY5kyZeTx3r17tHnz5sAPgnt4bhBYdmqf417zpMrgOOcT3xCwVLRLly6ldevWObV+//59pzROCBwC6kGXJUsWypYtm+woY8aMFBYWJs/XrFkTuM655ecGgWv379CwHYtp9O4V8p6LhoZRgTRZnpv7D/SNhph1sGTJEtq4caNZFqdFIwIXLlyggwcPyh6VNau6x/Xx48fp6NGjdO7cOYLyZWEEXCGwKeIIga81CpTsdfFRUj/ny9SleF11yUc/IOBk0S5evJiVrB+A9UcTa9eulc2EhIRQyZIldU0WK1aMkA5RVq+uAF8wAgYE7j56KJ1icIxpP1oliypXhdK9cu+WoTZf+oKAzqJdtGgRbdmyxZf2uK6fEHj8+LGDuilcuDAlSZJE1zIiEMLDwyVHC2dZw4YNKV48dmToQOILHQLZk6elD8Or69Jwcf/xQ4q4c502nDtCG84foVVnDtCWiGM0tkY7KpQ2q1N5TvAeAalobTYbLVy4kLZt2+Z9C1wjIAjs2rVLhnCh8dSpU9O+fZFOCtVhypQp5SlC7+A0Q1QCCyNghUD2ZGmpdo4iVtnUoXBVWnJyD320bALdefSA+m6YRZPqfGBZnjM8RyAESnbBggXyh+p5NS4ZaAS0dADoHHxcCZxirGhdIcR5niBQNVsBqpcznP49uo12XjpFtx7co6TxE3pSlcu4QCBk3rx5tHPnThdFOCu6ERCLSGjv3r2y21SpUsmFClZjQOjX1atX6cCBA3Tx4kVKly6dVVFOZwQ8QiC3Jqzr9K0rlC91Jo/qcSFrBEJYyVqD86xy4ATDTAPSuXNnCg0NtRwKIhN69uwp82HVgqtlYQR8QeDkjcjVdsniJ/KlKa77FAGnqANG5tkigJV3Ktogd+7cLpUsRgoljHIQxD3DicbCCEQVgU3nj9K/R7bK6ikSJKb0iZNHtSmup0FAF3WgSbc8TZiQ+RpLcPyQAacXqACIWgHmrlnE1B4+fFg6z+BEQzQCCyNgRODGg7u04+IJYzLde/RIRh2sOXuQFhzfSQ+f2B/WLfKVpZC4LziV5wTvEfBK0ebKlYsyZOBled7D7HkN5QSLHz8+FS1a1KOKKDd58mTCqj3QB6xoPYLtuSu0XSjZZvOGenTfdXKEU0cRhcDiHwRCWrVqJX+g7pqDJQslGydOHHdFOT+KCGDvAsWZQ3l6OnvARjMoD+pgz549cqc1Y9xtFIfE1WIBAolD4ru9i5SCJsiQOAXlTZ2Rmr1Ymoqky+62DhfwHIE4nmyT6HlzXJIRiF4EeJvE6MWbe7Mj4PdtEhlYRoARYAQYAd8Q4KgD3/Dj2owAI8AIuEWAFa1biLgAI8AIMAK+IcCK1jf8uDYjwAgwAm4RYEXrFiIuwAgwAoyAbwiwovUNP67NCDACjIBbBFjRuoWICzACjAAj4BsCrGh9w49rMwKMACPgFgFWtG4h4gKMACPACPiGACta3/Dj2owAI8AIuEXAq01l3LbGBRiBaEag3Zxq0dwjd8cIEE1v5d1rv9ii5b8aRoARYAQCjEDQWrS8WUiAv3lunhFgBKKMgLf6iS3aKEPNFRkBRoAR8AyBoLVo1fDz7OGXDSos+OiMQK/rrWWiem+acwlOYQT8h8C5c+dkYxkzZvSqUbZovYKLCzMCjAAj4D0CrGi9x4xrMAKMACPgFQKsaL2CiwszAowAI+A9AqxovceMazACjAAj4BUCrGi9gosLMwKMACPgPQKsaL3HjGswAowAI+AVAkEf3uXV3cS2wgc2EY3rTpQxJ1H7n4kSJHK+Q5uNaNdKooRJRH5i53xjypPHRLevE6XLQpQ+zJjL14yARODs2bN0+vRpKlmypEeInDx5ktKlS0eJEpn8jXrUQuwuxIo2UN/vVKEY48UXCjApUZw45r08vE908wpRtbeE4ssqzq8SJUlBFPfpRCPuC0T71hMd3EKULDVR6z7O7Ty4R9SjgXO6u5RC5Yl6z3ZXivMFAmvXrqVFixbR119/TfHji+80hsqjR4/o448/pt69e1Pq1OLvyYXMnDmTOnXqRDVr1qQffviBChUq5KI00U8//UR//fUXdejQQfYBpeup3Llzhz788EP68ccf3Y5L2+bs2bPp8ePH1LBhQ21yUJ47FO2TJ09ozpw5tHv3bsqcOTO1atUqKAccYwY1qT/R4weeDfeQUKQ9phF9Xono4hmiTr8QVW1BlDi5vf7jh0SpM5i3Ja1cKHJh2Xoju1YR3bkR2Yc3dWNQ2SNHjtCBAweodu3apqOG8gkJcfwMHGWuXbtGEyZMoBEjRsjfBDLQFtJcyf3792X58+fPU86cOemll15yVVzm7d+/n27cuEHFihWjF14QD9cAySeffEJDhw6lffv2yQeH2X2rrletEn8fQhYsWEC1atVyq2gTJkxIWJbat29fSps2LXXu3FneU48ePaSidvWAsolZ2ZgxY2j+/PnUqFEjNQS3xz/++INu3rwpFfvPP/8cUOzcDsZNAfkXhj+OsWPH0o4dO2TxePHiuanG2W4RyFOUaL+wRj2RfRvspe7fIXryiGhoZ7ui1SqA0vWsW8KP87GoV6ImUdZ81uWQc1msbFkx2V5GKXLXNWJ07sWLF6lBgwZSiUEJVK1aVXc/4eHh8sf9+eefU0REBM2bN09+VqxYQffuidmCRv78808qV64ctW/fXpMaeTp37lxp0WHKrQRT78mTJ1NYWJhKchzRByxA9JMmTRo5Vf/yyy8JCtFMpk2bRgMHDqQUKVKQt79R9AGrHLJs2TLC/Q4aNMisG5mmFG3lypXpo48+0pUbMmQIQTm2a9eOEiRIIPOgaCEtW7aUShbnUH6//PIL4UEyY8YMSpzYnNpSdANWXcHShqL2RKBkIdBbuL8kSQR9FqQS8t9//9Hy5cvpyhUxhWXxHwIdfiI6tpvokvjRTewj6ANBB3y3QBiewvLsWsPez1s9iDLkiOReEyUjunaRKJuJFZQqvYuxPaUmKr9JVNbNNGr/xkhF66LF2JJVunRp6tOnD3311VdUrVo16tixo7Tq1P3FFTTNt99+S9999x09fChmDkLSp09PRYsWpdy5czs+2bJlo1SpUkmFqOpqj+vWrZMKGwr1s88+o4MHD9LChQtp48aN9Oabb9L69fqH7qZNm6hevXqEpcMoD9m2bRuVKVNG0hOYthsFU+Q9e/ZILjRHjhyCkXr6vT8tCGoDbVSoUIG6du1qrK5T4FDsVnL8+HE6c0bMrIRgSq/kxIkThAcXxog+QBcAt+bNmzsUbrJk4m9YyKVLl+RDAedLliyhv//+m959911cOgm+AyUVK1ak7Nmzq0uXxy+++EIqWFAOwaxkcRMheNJAkidPLqdQrHAlHL7/F1aQCJ9VdnwJfGs+4ViAolWSsxBR0VfVleB07dYBZRTK1xvRtulNveekLCxEKAX8+IcPH07vv/8+FSwovhshynqqXr26VMi5cuUipSy8gQdWHxTquHHjHNXQFxQ7lOqDBw8c/C7oisaNG1P+/Pnp008/dZR/+eWXCRYtlBsUmZEXxVTf1Z4OoAWgaPPkySO5VUfDXp4oaxbYVKpUiW7dukV3796l+vXrEygR3M+oUaOkgm3RQlBcQozUABQwLE7cIyhJPBg8EWAIXeSJYCYOAU8b7CKpA3zBzZo1oylTprBl6+s3hi999lDBfYonOxxhe1Y/bVEo2JXT9Ip2l8i7dFZEAVwjqtlGlHtqoSiF68lYoGRBN0DggFv8p/3c6n84354zgRJ4++23pYWFKS+UnpKUKVPKU1isoBGiIqAcoEigWLUCvhGKFlaaVhHB0QQvfZs2bZys0jp16kgL+9dff6WRI0dqm3N7DmUI8VRRWTWoFC0eTLDujYKHA2iMwYMHEyz5NWvW6KgRUCdQ+kWKFKHFixc7HmbGdtQ1/ENK4HjETMITARWBe1b37UmdZ1UmBNMmbzyEz2qgMaZfOK4QkmUUcKgD2upT/xFOLyVXzqsz746IXIgv+DFEH5zYQ3Ryn+v6GoPadcHYlQuFB8dWjRo1CIaFEsUtqmtXRyiEf//918nLDWUEI8Uos2bNkopUO/1GGXCcENAaRoGyB+85ceJE6UQCXeGpwHsP8UXRgj7BPWIqfuzYMVPdAMcduOzvv/+eqlSpInlvOAqVQKdgxjBp0iQC3aBmDSrfeFSUDdLBpyve11jOeK0U7PXr12UWuOB8+fIZiwXFdQgrWT9/D7BGs+QlOn3Qu4Y3zBVcbRTIfCjZguWER2CFPZwMXLA7wcMAiv85iDpQUGA6jR+k0auvftTGdFVPewTPCz4QjuN33nlHm+V0DsusW7duNH78eHrttdcc+VDWsAIhZtNpWL6I+jl69Cht2bJF8sqOym5OFO1nZoVqq0KxffPNN4SIAK2ljTLTp0+XTkFwvEbdAO4WHDScVrC8Mc3funUrZc2a1RGZAZoBmE6dOlXyxGivf//+On5YOxacqwcELFQ8DJVzzFjOeI0oDTgGYQGjj169ehF8TnBYBpuEBNuAYvx44KBoP0BYlnuJUopp168diRBNgEUH735vpw76NrXf5htdxK+tsHCAXbDH0Y760p7+xIXZeXQn0e7V9rhaRTFUETwZPt7K1iV2hYsFDGkzE5Ws5W0LMaY8eDxwhbCYtAIqAbJy5UppoWnztOdQLpjOQxB1AC63fPny2iKOc8R3NmnSRHrmwZnCclXTYbSjqAsrLlilw6L0RjDVh0BRuxLE0g4bNkzSF3gQaAXpUF5duoi/TY1AAYLrRqSEUsCwWOHoUs4sKHhY8VC0OIJSgUBpg98FZhCEcSHyAREGUPR4+KBu06ZNacOGDbKMJ/+VLVtWKlVY/7Cu8V3i+4UDUvXlSTvRUYYVbSBQLiSeqPgs+sOuZNFHeBWi4tUFnxrJR0nnmNYZNqi9fTQ37D8YevTQeXQHNxON+do53deUVBmIcgqlD4UbC8QYH4uwKCgPhB+BS1VWk5q2woOP+FIlCBdSdACC9kNDQ2VdlX/48GFTRYuQJji04NW/cOECDRgwQPYHCw+xvFrlqRSqalMdVboqC56ze/fuBD7ZaIGqOjgqixbWHZxVxqgElMF0G1YfBDHB4FFV1ANi6PHAgWAGoO0L94KHFRSZNoICjjGrKAFYluBvgYdW8YG6gbMMyjVLlixSUcNChrNPRTvIQbj5DzQByqMdbUgcHHba/tw0Ey3ZrGgDBfMJYdGO7xXZev2n4Tr3bkWmGS1XKN2VguuDor0hnFbLJ0eWVWeIlR2OcCAXVq8q683x6nmiM4dijaLt16+fdCqpaJqrV8WqOyGw4PADVeFPStG2bt1aBr4ryBB8rxQtnD7KIlX5VkeEP8GKRcQAFkpAgYC/RLwsQr6wEEKJVSysUnCKe0TsL2gEPBygQMwWGqAvcKtQrviAY7WiN5RixTi0bwqANYuwNrSzd+9eQiQGlKiiOlAefVuNG/lmougZlZchQwaHQkcaFHjSpEklRogI8YQ3xwMDDnwoVTgXS5QooZoPyiMr2kB8LUsm2pXhQ+GggiDMS4VsYZquZOtiseJL0AthIswLsYRt+hJVErTC2G4i8junKmU/hsS3H9NkInqvv31FVwoRCxn36Vd4bBfRHyIuFwJKodsk+7m7/2FhI+oB8b5YZBFLBDGlsJZefPFFqXSwWAGecliniL9UopQZLFZ/CKawStD377//LnnWU6dOSQUMPlMJnEpqGq7ScLx9+7a8VGWhOGEVuhLsTQCBgsc0HQ8JOP48FfQJPnX58uWSelAPJnDXWmWM9tT4cA4aRFEhuNaKomW0aWbn6ANtYAEF4m21ihzjQH9Q1kas1MIQzBRw/9p6Zv08yzRWtP5GH4przUwipWTjivjZHlMje8GeBplzC+vxMNG8ESIcawJR37l2JZcynYirrSpIrFFEp/ZH1kmaKnL/A6TWaReZp87mj1Zn9tVhR7ZHXhvPpHIVCr/gK4LO8PzHaGwmmK9heSF8SokK0Ic1pXV8wQKFGH/Eqp6vR1ij6BsWMixarWMMSt6sX7XiycxZZjUe8JIQ8MawSqGYMa331NKDkoIla+W1h8PqjTfekMpQq3jz5s1rNSSv0mHFg64Bf6uNChk9ejS1bdtWhshhAYhWEJKHB5hROWvLBMs5K1p/fxOwTMMri2U+wlqFo+XzscJqzajv5TfBs54/TtQhXJgEd4n+EpZsz+mRZboIbreFUMgviK8ny4tEH9idMJEFDGcXTxEhakHJ0R1E+LiTleIBMHybPTzMXdlYmq84wUyZxExBI55aY5oqlqewlqFo4aQClYFrcJ5Q8maUhLImzfKsOlGKFgsdlKICFeCpogWnjUgJ8LSgHaDAILAmsYQYygxLjEGDwAGmBJEI7jhaVdbVEYoeihahb3gYKlH3dejQIRnFodJxVLMRxbdr84LtnBVtIL6R+u8TlaknLNaRRBHHhVNsnLBIX9D3hJ26lIBagGWrBAr6re72nbyqva1SrY9wZIVmI7pwwrqMWc6Vc8+1ksXUEwoPCtC4+QsUjz8EHnUoI0z/ixcvLpvEaio456DYsJxVK/DUIzIBliXClzwRxKru3CmiUYTAooUFjXaxNwPihz1RtgitQhvYRAZ9Y7wQjAfRBbhWu2QhpMvfolZ3QWlql9OqcWAWok1H/4rC8Nd35e970rbHilaLhj/PQRGcOki02Y01ij61Cxe0Y8DKstDsRIUraFOdz0PiEX0xjmSUAqIGYFW7EiyowCq1F0S951gQdA8Bp6l+0AoOLe/oi3WLMCc4burWrSujBtA+FjBgsxWEOGkdU8hT4U1mex0g30zg+IOywUo0Na3HdBtOLBXripAtd4IdtJTAsgXfix3I/vnnH5Usj0rB6RJ9uMDDSC0+wH4IyiJHk4goQJQExgHeXSuIHoHlrepq84LtnBVtIL8RxKVuXhD1HhChsHOFe0WLHnK/7Hk/4IchiYQif05FOV8QA4qIA6OoaASkQxG4EixiwDQWSlO7kgtxreBKQRUg3EoJuFfsfIU0KNZSpUrJLPSDcDDwnp5uU4qlvNhfAVNvrSMOfCpCnrDw4b333nNEUKgx+OuIvQysVqKBLvFEMKtQDzNESmgtVxWLC5wQN6sVRBxAFIWgzQu2c1a0gfxGyjUSVuYDIkztsaG3dtUW9hz4oaW9986/E6URlqhW7t4UWxoKTzJib/0p2B1M8bfphbX8nAqUEOJmsSbfbGqttZK0StcMLihMOLqwNwHiQzF93759u9wxDEoWGzfBMtMKuEhwtAhRwkbccIph42zE5yL2VMXSauuYnUOR46GBRQhaThfhUqAnYCEihhf52FjHF888xgv+GPekBM4rK44WG+ds3rxZFbU8Kucf6AHstKYcl6gA2gLhdYjgQIyyVhBVAT5XLZjQ5gXbOSvaQH4jiYXFWPs98x6uRkSmv1RazJECrPSwJwLe1jCmW+TGNrmKRI7hOTpDeBe82Zi+g8M0E62V5G6qDG842oLjBtYt2saeBVCgmLqbKQIoFShWKBKEYsE6AwcKRYOwNE8ES2hRH/wyzo2CqAtQF4gmwKo2LDSw2hvXWNd4DUcYlDaWIeOelMDzb6VojfGzqo7xiMUR2MQblj0UqlbUIhIs1jDy2XiYwWJHeBceUCo2Wls/WM5NFa02/CVYBhpjxoEwq7H/I0qaUkR3u+BAtau+ugqKQYQjmcpDYREjzrXjICLsN+uJTBKxnHNH2N/KACccYneh2KFstfJaZ+1VrDzH6iosUsCyWAh4WViL+JFahTKhnFK0cBJpLSzkGSUsLMyx96oxz9U1QpqwUg0fbwSOI2zLCGscG4vjnqxeTYN7x6IJWMl4EID/hBUMa1NrAVv1j7AuPIzAh2KzcLw5Ac49Je5oFVXOeEQ9bCoOegUYQ2C5GkUtKwbfbDbzwEYymHFgXwk4D7HIIhhF9+vGEwsfFh8QQCwsQrauiA/ZPbduW7siKAKXZUUUwuBOnitavGUB1ISrLRGrNI9cROF2gDGvwNKlS2XMJywx/KihVMB/4scMXhPr49966y0nC0rdKRxBmG5/8MEHsi6UG4LiURcOGEyhraxh1UYgjrDgwCljqSw23MaCCNAEVgInGN6sgPhdHLEyDZYfPoULF6ZevXrpYntVO7AQIbC0oWThwIO1DkEYlhIVLYBr4IKHB6gF0AEqREyV1R5h5WMWgPuARa62q9SWwTksciw2wcMMDxYrweIP0DHgcV3hYVU/0Ok6RRvozp6L9svUJ0ohlC0kfgLxn4fKVlYw+08oWVii3kQIlKxtD9vC1olKwA/jBY/ZhBJ+/WP9huOqTCw6IrRJWbFYc48fLKw+KCdMNTFFxwfe7BzCOQWFBP4SThlYcfiAMoDChlJFyJVSKtj2D1796BRYbVA0sNwwXUcsaxWxRaEnAosRG+rAaw+eE/cIxYYwM7M9AaBIsbeCEmyQA6WoBDt0KVGbb+MaeydgVzBEQGgtXS2nq+rhCHrF3R7AKmwN0RRmFi3awf1gDwa1mQ+OZsuUUfZZSRyxEYX4JQefKI9lnj1PlVbwDTG4R3R4mz3cK1SEmRkXTAT3yL0aXa/tglIRYnzzABQlds3CtB9Ta21QOxQJHEPgLdXKME87hcUGx5cVL+lpO96Uw/jhvIM3HkdwpFF1asGqhcMOEQoq2sE4FjjXQDdgMxtYm6ActFbi8uXL5bQf9fBqHUQeKMHvFhuDq13BMJ1fvXq1bv8CzCxgpeLB5+4+YIHjIYd7xwPGTKDsYekrUVtAqmt/HjEWiAqj87RtVrSeIsXlghIBK0WLweJHDwWrOEDjDcDqwoojKE4oXPyo8aOFooEFiSM+sGQRZwvfBZST1hlkbDMQ17/99hsVKFCAKlWqFIjmTdtE1AXC1UCfGB1UWNoLjhcKFflGUa+wAX+MsWtXeqEs8IQTD6vxEI1hjGE2tuftNdr1JG7Y23ZRnhVtVFDjOjEeAVeKNsbfXAy+AdAHwTZ99wecUVW0bpYQ+WNo3AYjwAg8bwjERiXry3fI1IEv6HHdZ4ZA5WPPZwzwMwOcOzZFYGnn46bpxkS2aI2I8DUjwAgwAn5GIER59/3cbpSbazenmq5ur+utddd8wQgAgRUpGAdG4NkjoDhbdyNhi9YdQpzPCDACjICPCAT9goVmrT/38Ra5emxEYMWMsbrb8pQr01XiC0bASwSqDArT1fA0npYtWh1sfMEIMAKMgP8RYEXrf0y5RUaAEWAEdAiwotXBwReMACPACPgfAVa0/seUW2QEGAFGQIcAK1odHHzBCDACjID/EWBF639MuUVGgBFgBHQIsKLVwcEXjAAjwAj4HwEZR/vE9oRO3rhMl8RbV5PFS0hhKdJSAm82mvb/uLhFRoARYARiDQIhXVdPoUUndtJdzTus4oi3AlTJ+hJ9UaIuZU2WJtbcLN8II8AIMAJGBPDeMbwKB5uUB+p9iSGzjmwx9ks28W/Jqb206sxBGlejHYWHZncqE6wJBw/soTEjfqX8BYpQyzbvWw7z5/496dzZ0/RGs3eoZOnypuXOnztDKJfnxfzUruOnujJ37tymvbu3087tm+nwof2UMVNWyvdSQSpWsqzYOT6trqzx4sTxIzR8yI/0TtsP6MV8BY3Zuusl/82llcsWUcT5s5Qn70tUvtKrluNVFf3d/uCB/ejypQvylSGqj/QZMtGL4n7zvliAsmTN7rR5845tm2jCuOFyrMDYSs6cPkkDf/yGKlerRXXqNbYqxumMgN8RWLFiBXXo0EG+Aw1v4jh9+rR8cSXeYuFvkdRB3Rzh1K5wFcomrNcLd27QxP1racK+1fTgySPqsupvmllfvEYjHt5/FfySNl16mjn9L1q9crGloo2IOEcjhw2wvx/q9i1LxbVh3Ur6959J9HZr/Supt2/dSB3efYOuXrkkFUziJEnp9q2bEpxUQskOGDyGyparYgrWzh1bqN07jWTdfPkLuVS0X3fpSNOnTKC06UIpR868NHXSHzRCjPvDT7rRB527Rlv7s2dOJihvK8mZKy/1/n4wFS/5iqPIyRNHCfUWzJ1BRV4ubnmfVwSGKIfvjRWtAz4+CTACeEtEvXr15CuQ8CYJyLZt2+QrzfG6ok6dxMtQ/ShxG+QqRj9UaEa5U6an+C+EUBbxAr8vBWXQrpBdUZy5dZVWnzngxy4D2xSsyYKFi9LFCxF06OBe084Wzv3HYZ2tWLZQvHzvsmm5rZvXy/SSpco58mFhtnyzNj0Rr+P4ZegE2rz7LG3dc44WLNtG3/T7Rbz65D61easBbd601lFHnaxYupBaNq0llSzS8FI5K4HygZKtXLUWLVm9h/6csoD+W7mTypSrTIMH9qU1q5Y4VQ1k+xkyZqadBy7Jz5rNR2jC5PnUq+8gqtewKR09cpBaNKlB3/d2Vv54JUzXzzs4XmzoNGhOYASiGQG8/QGv4sG7zvA6HiXqVex44++uXbtUsl+OcT8pWtO0oRb5yjrS98nXYTsug/6kYmX7u93XrFpqOtb5wsrCe4oaN20p39g5d9ZU03LbtmyQ6cUFHQC5e/cOff15R4IFO232CqpZ5zXx0rpkMi9Hzjz0Zot3aejISVKB/jH6N5mu/sN7kr78tJ14F9UDeuudDirZ8jhv9nSZ16Vrb/Fiu0TyPFnyFPTjwFHi5boJaNqk8bq6gW4fr4dOkDCh/MD6BN3S7K229NMvo+k3cc8pUqSisaMGE2YBRtmzazuNGj7QmMzXjMAzQWDmzJnytfG1atVyorzwUkoYQHhxpz8lbmji5KbtJZWvyrZnXb4b+Xph08JBlli+4qtyRGtXL3MaGXhXWKolhJXavpN9ZzBQDUa5dfMGge/NlScfpU5jfxPv1L/HiRf4XaE27T6ibNlzGqvI69JlK0oFBMtW+8plkOzdv/2JRv4xgxo1eVuWdWXR7tu7U/aN/rWSLjS9eMd9bjpxQj+VD3T72jEYz6tVr0ujJsyUyd/36aqz1D/p0lPiN3hQPzoiuGwWRuBZIzBkyBA5BLwl2Sh4/XkCYchMnDhRvmbemB/V67hWFfdcPuPIypMqveM8JpwUDi8uLaxN61fLt5lqxwxrFlKnfmOpLIuVKEu7dm6lI4f19Mh24cyBIiyh4R3//ON32W6Llu20TTqdY0r9+5hpBCtQK3XqN5HcrSsFq8qHps9ID8UbWI1y/fpVOnb0oHizaGZjlrinwLbv1KEmoXCRYvRysVLCQbiDTp864chJlToN9eozUN5LV8E5ax8+jkJ8wghEEwL4+1u3bp3sLUeOHE69gp/NnDmzmL3epS1bnAMFnCp4mKDXBE8rQREM2rrA0UShtFkd5zHhBArulQpVCZEBO7Zt1A15/pwZMoSjeq0GMv31Jm/J46wZf+vKbd1s/zJKlrbzsw/Ea6jhECpavLR4x3xSXdlAXBQrUYaUQ0nbPqxv8J5lBVfriwSifbQJOX3quDyq/2rUbki16zYS38UmGifoBRZG4FkhgDci4BXykGTJ7LSfcSwq/dixY8asKF+bKtrB2xfR5gh7J69kyksvh4ZFuYNnVbGCCIOCaHnas2dOyR97mVcqOUKwwLMmSpRYRhdoLc2tip996gg7fdpupWXKks1vt6Ttz9ho4zdaUuLESeirz9rTj9/9T3jv/6Hvvv1KfuCYqvdaU2MVp+tAt2/sMF1oBpmktWhVme69f5YUwqCfetPxY4dVMh8ZgWhFQKs8lUI1DkCla8say3h7rXvDwt1HD6j3+pk082lsLUK6vinzurdtBkX5chWqyXGAp/34s+7yHKFGkNqaeE04s2DdwqKFIwccKxxLO4X1lTVbDkovpvAQxHtCMmd2VrQXIs6LeNseGm7SJqzeZNRTTJnNBHHK7iRn7hcpf8Fw2rxxjXAkDdIVRxgVnE9WEuj2rfpNmTK1zELMb/awnLpiiAYBhfBRx7ekQ3HitEVOjghdBb5gBAKAwLVr1xytxosXz3GuPQF9ALl+/bo22adzh0V7+FoENZ07xKFk0yZMKhcrZEpq/YP2qecAV4bT6KUCheWCgps37IDNE7QBwH21Rj1d74o+UE6xg/v30G0ZXxsZ1pUokd3zDyeXUe7du0OLF80hhH7hM2vGJKm4jeW8uf51QB+pZKtUq01z/9tEG3eeov4DRhI45TmzptD4MUO9ac6pbCDaR1QGBDMEM1EUwhZBy0wYO8ysCKcxAgFFIGvWSBoUq8HM5Pbt2zJZW9asnDdpUtHOOLSJ3pgzmKBsIcXT56ApdT+kAmmyeNNW0JVF9AHI7w3rV9Gpk8dpl1gsAEs3eYqUurGWKlOBMgtKYNH8WTKEC4oAgsgEJVj5BUHMqFEQgbBFxNOqT7Hidq7SWE5dO6b0FnG0t8TiB6xug+U6bPQUyi1WhMGCbdioGY2bOFsG/0+bMl4153QMdPtOHT5NgCULSZnKbtk+TdYdFIUw4Ide4jvxHwem64QvGAELBLQOMCuL9eZN++IjbVmL5jxOjvvV6sn0v7XT6N7jhxRXxJZ+GF5dWrIZkuiVkcctBlFBFU+7VsTTguOEINrAKIipfa1xC2nF/rfgX1Lxs1pFiyWncLIdORz4ECUsorh3766Iy21jHKqMoW3YuDkd2LebLl20PxidCrlJCFT7O7Ztlj2ruGOzYYBC6Nl7gHygdfuik4ZuMSvNaYyAfxFInjw5hYaGykYvXrxo2vjVq1dleu7cuU3zo5IY998jW2W9FPET0chX21LHIlWFwnUwClFpM2jqhBctRUmTJSfwtPPnThfxcQmpyqt1TMfXsFFzmQ76ABEHcDhhDb+SkJAQEXFQhhB8v3xJZESGytcePeFIUd7CoCVFdSQSzjAzUWFjEefPmWU70gLdvqMjcQJc1q5eSmE5cgt+Npc2y+kcDshadV6XnPikP0c55XMCIxBIBFq0aCGbX7t2rVM3ERERhMiEfPnyyU1mnApEMUFq1DwpM9DUuh9RmYz+0+BRHI9fq0E5IsLg2NFDUhFUqlrTMjQLji9YsIhSQHSC2UYzH33aTY7vf191sly268kNOKb2FoWxUQsElriZLFk0VyaH5TT/vgLdvnFMwOvrLzrK5CZvvmPMNr3u0WcAYV8ILDNmYQSiEwEssYWxsmzZMqduN2zYINP8vtdBukTJ6M9aHeQeB069xoKECpWqO+4CsZyuRDnFUEa7UEHVAZeLZbvYR6FGxXD65efetH7tCsnb3rh+jcCt4oO11L5IARFtAMU/cfwIgtNKrahCNMTIYQNp04bVco+BqMbzRqV99K3uDxvBIERr3ZrlcnezhrXK0v69u6iacDK+2/5jj25dRSF4VJgLMQJ+RADca7t27WjhwoWkFCuahz9nwIABlDdvXmrVqpUfeyQKKZkhF60/d9hlo/nTZKbMSa0dHC4rP+PM8hXtYV6ISYVF60rgFe/d4zO50KHE04UKxvJ9fxhKVcWS055ff0xDf+0vP8YyuPZECVpZnthTYNjoydSqWV367Zfv5QdRFNeFMsfCCVjeXbt/Z9atLs2f7cPRVayAPdRN14m4wMyhRav29NmX33gVsqUoBLVaz9guXzMCgUIAy3DB0TZr1ox69+5N6dKlo7/++osOHz5Ma9assVzMENXxhMw9tp3wcSW1worQzxXtHKarcsGYlzFTFmrboTNhSavanMVqnFCOUBaILMAmMVaCkKty5avS8eOH6cSxI8K6O0IREWd1jh0VDmbWRqpUaaTSz5k7r1m2TMuTN7/YtWu33PIR1uIlsR8srNyChcJlHLDiac0a8Hf7DV5vpnO8xRX7NiQXG9ykSJlKxhWXLFPeKa43V+58cvMcd/vt9hALGdKIbSBLlHrF7FY4jREICALYGwSKddKkSTRlyhQ6f/48NWzYkPr06UNZsmTxe59x4v3vdZu7VmuGFaYBFe0Esruyvua3m2O3QFU7w1/fo075yAg4EOgww85jq4SlnY+rUz4yAgFDoMqgMF3bnv7dhext1V9XkS8YAUaAEWAE/ItA7Ijj8i8m3BojwAgwAn5FIMSvrXFjjAAjwAjEYgQ8pQqMELBFa0SErxkBRoAR8DMCbNH6GVBujhFgBGIPAkbnl7s7s7J42aJ1hxznMwKMACPgIwKsaH0EkKszAowAI+AOAVa07hDifEaAEWAEfEQg6Dnav8f+5OMtcvVYiUAK/V15y6Xpa/MVI6BHwIpr1ZdyvsLOX2bCFq0ZKpzGCDACjIAfEQhJkyaNH5vzvanprbbJRi5fviyP/tx81/fRcQvBgkCVQWODZSg8DkbAgUDGjOYbL7FF64CITxgBRoARCAwCQc/RBua2udWYjoDi0L755ht5Kz179ozpt8Tjj8UIsEUbi79cvjVGgBEIDgRY0QbH98CjYAQYgViMACvaWPzl8q0xAoxAcCDAHG1wfA88CkaAEQhCBJQvQA1NxclaRReocsYjW7RGRPiaEWAEGAE/I8CK1s+AcnOMACPACBgRcCjae/fuiRcAXiIcWRgBRoARYAT8h0DI9OnTafPmzXTt2jVHq8mSJaOiRYtS7dq1xdtOkzvSY8LJ7t276eeff6aXX36ZPvroI8shf/3113Ty5El67733qGLFiqblTp8+TV27dqWCBQvSl19+qStz+/Zt2rp1K23cuJH27t1L2bJlo8KFC1P58uUpbdq0urLGC7zSuF+/fvTJJ59QoUKFjNm663///Zfmz59PZ86coQIFClDNmjUtx4vXi+PNnitWrJCvTc6fPz+99tprVLVqVV2b6uLBgwc0evRomjFjhnz1cunSpalu3bpUo0YNihcvnipGiFWNiIjQveU3c+bM8n4x/rCwMKfXjG/YsIEGDx5MlSpVorZt2zraMp6cOHGCunXrRvXq1aOmTZsas/maEQg4Avv376cbN25QsWLFCG/HDYiIP26b1adly5a2nTt32q5cuRLtn0OHDtnw8VbEu9pt4lXcNkFWW1YVSkuWEYDaGjRoYFluwoQJeEOwTShsXZl169bZxHvgZR76Eg8jeY6ySP/vv/905bUXQjE76g4aNEib5XTepk0b2W6GDBls4mFgEwrcFidOHJtQfE5lxUzEJt5RL8snTpzYJpSfLIvy/fv3dyr/5MkTW/369R3lhcK0xY8fX16/+uqrNvGH56iTJ08emY77M/vky5fPtnLlSkd5nEycOFGWRZv4G7KSTZs2yXKfffaZVRGX6b169bLhw8IIeIvA8uXLbfjbxW9FKFlb+vTpbQMGDHDZzNmzZ234eCtxQ0JCqE6dOvTtt9/Sr7/+Sr1795aWLNLv379PI0aMIFg+MUVgTRYvXpzgHdyzx/xV5dOmTSOhaOQtzZs3j9S+CsZ7XLNmjUzSWrywMKtUqUKPHz+mqVOnypnA9evX6cCBAzR8+HCJGSzC1atXG5sj9FW5cmVpPSJTfFlOZVQCLNMxY8ZIS+/o0aMk/iiklQrrFKughDJXReVRKFP6+++/SSgs+XQ+duwYHTx4kMQfEsF6x1NbK99//z3hXjp37kxXr14loQzluD7++GPZ9ocffqgtTlmzZqW7d+/Kz/nz5+V4hg0bRi1atJBtAyP0bRT87bRu3VriZczja0bgWSEgHvDyt4XZFn4rmNVj5ogZ7G+//eb/YS1cuNDUWv3nn38clu769etNywTS0o2qRYsnjVBE0koaOHCg6YPnlVdekRbtu+++K8uJKa5pOUEFyPwLFy7IfEEX2MQmPNIiFdN/0zpLly6VdRo1aqTLf/TokbRIxZTcJpSYy/GhorI2BS2ha0c8QGwJEyaU343KUG2Hh4erJMdx3Lhxsq8ffvjBkSYoEZuYItkETWCDZasVtCWm+9IaVpYoLNrs2bNri+nOZ86caUudOrXsZ9myZTJPWbTiL1amC6pEV0ddsEWrkOBjdCHw8OFDm6D6bKVKlXL6++/Ro4fub984pihbtCVKlDDV3mXKlHHwbuAyY5KAx4QsXrzYadjgXdeuXUsVKlSQTy8UGD9+vFM5cDbge8FzCjpA5o8aNUpav7DccuXK5VQHCbBYO3bsKC1bZTUjHdwPOEtYtbDwIOJLlEez/7Zv3y77fumll3TZgkYgofikdasy9u3bJ78r1a5Kx7FatWryUvsdLliwQFqY7dq1c3zHqg7G2bdvXzm2WbNmqWSXR0G/ENqEABvtfaGt0NBQyfNinCyMwLNGQBgG0j9Tq1Ytp79/zO7x94vZvT/FEXVgbBTUgSKGtT8cY7lgvC5ZsiQJC0s6hcTTSzdETPdxP2+++aZUlnBeYRphnFoLK17SC1DISoYMGSLb7dSpk0oyPQ4dOpRmz55Ngr/V5aNPKD5P8MyUKZMpZYNpPmiKLFmyONqGs05Y3abOPxVgnTNnTkf5RYsWUdKkSaXTy5GoORFPegd+mmSXp3hgly1bVjoIjx8/7igLKgd4gIYSnLODsnEU4BNGIJoRwO8YAuevUcSskBIkSEBiRiYpNWN+VK/1mkDTCvg9MY2UKdoftaZI0J5CwVWvXp1u3bpFUJhamTJlCuEhIqb2Mvmdd96RR+H40hYjIz8LRYFoAUE7SCWlKxyAi3Llysn+wNVqBdY3eE9lqWrzzM7nzJkjk/HwUQLOF5yrcFSpJN0RD1hY7EpJ6zJdXGDMEHBeWgHWiCjAdyHoHG0WnzMC0YoAZpnCmS37zJEjh1Pf+E0gogb+iC1btjjlRzXBVNFiiqem0whbwlQ1pomiD7ROI0yfEXYEh5IKwWrSpAklSZKE/vzzT52lCXoBoixaWGmwRAVX6TcoXFm2sP5gdeJBgNAyOPA+/fRT+YGShBPKncBJhykQLF5QQUoQL63oEJVmPGJDeCsnobGsulbLEo2KFvmwIkAhdO/enQT/rqrwkRGIVgRgPCjnPsJYzUSlm/0dm5X3JE3udXDnzh2CBxlWG35cuIbg7QatWrWSFqAnjQVTGXj+RWiT5GkRUQFRtIE2XhOgwuLCg2W58OyDY0VEARQyrDpM4SFqOmymaPHlwVupFCeOaNfKe6nKyYYt/kO0AGKZRdgUCUeWrhTojlSpUunSzC7Al4JqwL1paQx8x0WKFDGr4kiD1e/JOB0VxAnoGghifo1vxlAUQuPGjSWFgPvC98PCCEQnAlrlqRSqsX+Vri1rLOPttbRosRoM0+JTp045lCwagjWnLD9vG37W5eE0At+CBQWw7CCgDTA1QBC/VhR9oKz4Xbt20c2bN3ULA0RsqqyCh5FR8GACwQ7nET6gIYxUhLGOu2uEcEEZiegDGaYmIjykwoSSBZ3gjqyH0w2LEURMrFyEoO0PShT350qQDwvUG1EPaIWVsa6iEBD6BscgCyMQ3QhoF2ZpF+Vox6EoNaU3tHlRPZeKNkWKFHJ1DqaoWCkFkhjWBuI4MeVTpnZUO3lW9UAfwDqFpYqnE5QuLN2UKVPqhoTVS2FidRNWyUFZKH5W0QYoDAoFYnSaIQ2WL75A9VFcJfLMRFmK6mgsAyWH1W3oH4obkQ+wYN9++20Z44oVaPhurAQPTDw88LBRDw9tWUzx4TxzJch3Ry8Y68OShbh6D52iEBDbC66YhRGITgRAuylBZJGZYNUnRFvWrJw3aVLRwvkBhxeUDaaroAsQ+gNB0L9ZmJQ3nTyrsgjfgICnBW0AgeffKHio4J6h4ET8sAz/QhntQgUQ5MApOkKUYI1C4bdv3944VOkRxVixwADLYo0CEh/Tc1jAWMAAZWsU0CFQxsrZacxHG3CGKs7VmG91DboFAqvbSjBDAqWCP2YEi1s9bKzqczoj4AsCWgeYlcWqZnvasr70ibpS0Zo1gmm3coIhnjQmChxAsNbxoABtkChRIjkVN7sXsdxYWvGwAGHR4mmGB48STLcRcQBP5Ny5c1Wy6dFT5WFVTk1v4KQzE/CtqKssSFUGivONN96QljssR1jqZoJ0/JEhzMtMoOgxE1APKrMyxjTs+wCc8+bN68TPGsviQYBxisUNcjWdMZ+vGYFAIYC9WxQlJpbrm3YDvwbE6GcwLexhoqWiRX2x9lc2A+soJgqUIyIMEHcKBYlgZHjyzQRxppiqQ/lgoxOtNavKqxcBgl7x1iOv2sDRSsGqMmqjGW3EhMrDEXQCrHAoNSVQsmKvA0I4V5cuXahDhw4qy+moOGrwvFCoWoE1+/nnn5NYfWb5UNKWxzmiOcQqO3lfrjaQ0daDVQtqwhUFoi3P54yAvxBQETsqskjbLmaJcG7DGY1NZvwlLhWt0vjKm+yvTqOzHa1Vpo02MBsDeE0lWn5WpcEShELBFwElJ5brSasMihxWKKYc+FhNyVU77o6gb8D7ItAfTjFFV0ApIgIBTrLmzZs7HhqIDQQlghCw119/nbDvgSsB5wv6QSy/lkcoSrQBJxUse0RY4Ki8r2gLfav7Q3gYQrTEcmO5jwJ2SsNKNihwKGlPREUheFKWyzAC/kQA+3hgVogZlVEU/eVuUZKxnttrYb2Z7mOANejixyvX1Aurw7RMsO51ICxGhwglgnWuNmHJ2gTv6Ug3OxGKRJZDeaE8zYrINLEZi01wtrJdlDX7CCVlWR87eKGOdv8BY2FB18jdhFTb2I0MexzgWljbNvHkdVTBjmWqnLB0Hbt2ac8Fv6zbkUtMj2xiG0xHPUGrOM7FH5kOK+x1oNo3O2L/hg8++MAG/JSovQ5+//13lWR6FBSCbFuEopnmu0vs1Yt373KHEec7IyBmfDYx47VhHxclwpiQvy1hROl+Kyofx6judRACLg9TTsVHirZkDCk88DgHr+nOiy5+fEEr4Fq/+OILGQ+Le3EloBW+++47GVmgnZYb62DvVKw8g1WnPuBLgZcSqxAn5MOaw76vmJ5YCfaehVcenPGOHTuk4wv0BqYzsMy1cbG4LzMnn7FtOPOUIPICNMOkSZMkJ437QGQF2jauOkO0A3bsUoJ2UB8zHcQVw9I3xvVijwZYDoiQcCX4+wNFZTaDcFWP8xgBXxDA3x1m7NB92LEQNBbCJhHmCh+NdjbnSz+qbhzxw5LaASQxFA06V/sDgOME5+YuuF015s+j4kD9SUj7c3zcVnAgoHhzUCwsjIA3CCBsFYYGjEoYEg0bNpQhlK62HABtCPE2IicEmhzKFTFl2rgyLNvE8lTlofPmBrgsI8AIMALBjgAWJsAXgU+gJURwXHKZJgLUEbuJaS2mcvA6szACjAAjwAj4jkAIuD6s5HG1msf3brgFRoARYASeXwRchnc9v7DwnTMCjAAj4D8EWNH6D0tuiRFgBBgBUwRY0ZrCwomMACPACPgPAVa0/sOSW2IEGAFGwBQBVrSmsHAiI8AIMAL+QyBELQzwX5P+bUkFpPu3VW4ttiGgAslj233x/QQnAt7+vbFFG5zfI4+KEWAEYhECIcEaP6ss7WatPdsNKhZ9J3wrXiDw99ifZGlvl0R60QUXZQQcCChL1tu/N7ZoHRDyCSPACDACgUHg/yVVJPw0sSVZAAAAAElFTkSuQmCC

zjdh 发表于 2024-1-18 12:39

本帖最后由 zjdh 于 2024-1-18 12:42 编辑

B2=SUMPRODUCT((DATEVALUE(Sheet2!$A$2:$A$7771)>=(TODAY()-30))*(Sheet2!$B$2:$B$7771=A2)*Sheet2!$C$2:$C$7771)

hugeinfo 发表于 2024-1-18 13:04

念念念念 发表于 2024-1-18 09:35
不好使啊。大佬,我就是这样的公式。输出结果是0

你举例的文件李没有符合条件的另外 这个最近30天是按照现在的日期算还是满足条件最后日期的30天内?

念念念念 发表于 2024-1-18 17:44

zjdh 发表于 2024-1-18 12:39
B2=SUMPRODUCT((DATEVALUE(Sheet2!$A$2:$A$7771)>=(TODAY()-30))*(Sheet2!$B$2:$B$7771=A2)*Sheet2!$C$2:$C ...

列必须固定行数么?可以直接选一整列么,例如B:B

念念念念 发表于 2024-1-18 17:45

hugeinfo 发表于 2024-1-18 13:04
你举例的文件李没有符合条件的另外 这个最近30天是按照现在的日期算还是满足条件最后日期的30天内?

按今天日子最近30天就行,主要用sumifs提示最后today日期输出是一串数字

zjdh 发表于 2024-1-19 16:24

运行速度将大大降低!!

念念念念 发表于 2024-1-19 21:44

zjdh 发表于 2024-1-19 16:24
运行速度将大大降低!!

感谢大佬!非常感谢!
页: [1]
查看完整版本: 求大佬帮忙!想统计近30天每个型号的销售数据