:Year-end reporting skills: Use functions to summarize monthly data-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Year-end reporting skills: Use functions to summarize monthly data

Year-end reporting skills: Use functions to summarize monthly data

Author: daogeziyuan • • Table skills • Views 846
  • Picture and text skills


At the end of each year, we often need to summarize various data reports, so how can we use functions to summarize monthly data?


教程分界线.png

◾Take this sales form as an example, place the cursor at I2 and enter the formula:

=SUMPRODUCT((YEAR($A$2:$A$278)=I$1)*(MONTH($A$2:$A$278)=$H2)*$C$2:$C$278)

The meaning of this formula is to first use the Year function and the Month function to determine the month and year of the sales date in column A.

Then compare it to the year specified in column I and the month specified in column H, and multiply the result by the sales quantity in column C.

Finally, use the SUMPRODUCT function to calculate the sum.

Place the cursor in the lower right corner of I2 and pull down the fill formula to the right and left in a cross shape.

You can quickly calculate the total monthly sales quantity of this table.


录制_2019_12_16_15_06_22_407.gif




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-hui-bao-ji-qiao-qiao-yong-han-shu-hui-zong-yue-du-shu-ju.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 于晓敏 Columnist
48 196
single-end

Related Suggestion