Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/nian-zhong-zong-jie-xin-ce-lve-han-shu-zhu-li-yue-du-shu-ju-zheng-he-ji-qiao.html
"New strategy for year-end summary: functions help monthly data integration skills"
Of course, the following is the rewritten content of the article: --- As the end of the year approaches, we often need to summarize various data reports. So, how do you cleverly use functions to summarize monthly data? Take the following sales form as an example. First, we position the cursor to cell I2, and then enter the following formula: ```plaintext=SUMPRODUCT((YEAR($A$2:$A$278)=I$1)*(MONTH( $A$2:$A$278)=$H2)*$C$2:$C$278)```The function of this formula is: use the `YEAR` function and the `MONTH` function to determine the year of the sales date in column A with the month. This information is then compared to the year specified in column I and the month specified in column H. Next, multiply the comparison result by the sales quantity in column C. Finally, use the `SUMPRODUCT` function to sum all the product results. After completing the formula input, place the cursor at the lower right corner of the I2 cell, and when the cursor turns into a cross shape, drag right and down to fill the formula. In this way, we can quickly calculate the total sales volume for each month in the table. In order to show this process more intuitively, the following is an animated picture demonstration:![Recording_2019_12_16_15_06_22_407.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/0d22a719e4929d6b97e5a3b768f4fcef.gif)- --Please note that the above content retains the HTML and image address information in the original article.
Like (810)
Reward
支付宝扫一扫
![支付宝扫一扫](/wpcom/picture/wechat_shoukuan.jpg)
评论列表(196条)
测试