EXCEL表格年终汇总每月求和函数公式 常用表格求和应用 按月求和
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 一年中每月的数值汇总求和，如下图。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/29b48ea9c91142909eae67cf24b4b46e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727970223&x-signature=YAcItzAokAoDja0x4Km3hg5Dutg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 做表格汇总统计的<span style="color: black;">朋友</span>，每次到年终<span style="color: black;">或</span>一个季度就要进行汇总求和，<span style="color: black;">咱们</span>只要<span style="color: black;">把握</span>下面的公 式，以后再<span style="color: black;">亦</span>不会发愁了。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.内容数据</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span><span style="color: black;">咱们</span>前期<span style="color: black;">必定</span>得输入好数据，<span style="color: black;">按照</span><span style="color: black;">每日</span>的日期进行对商品的统计，例如数量和金额 销量等，输入<span style="color: black;">每日</span>的数值。如下图。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a0db22bd7fa741a981e8fef1a5405341~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727970223&x-signature=ZBTXrzxwKEBE0biH8L8DaVrTatY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2.汇总表格</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">输入月份，右边将对<span style="color: black;">每一个</span>月份的<span style="color: black;">营销</span>金额求和，</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 在E4单元格输入函数公式=SUM(IF(MONTH($A$2:$A$13)=D2,$B$2:$B$13))，</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/501941195a0047cf81e15126b103ffe2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727970223&x-signature=RoFoWx0EuU%2BRiK4ZMVMpHcEFd5I%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 分解如下：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> MONTH($A$2:$A$13)=D2从$A$2:$A$13单元格区域提取月份等于<span style="color: black;">咱们</span>需要的月份，</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> $B$2:$B$13是<span style="color: black;">暗示</span><span style="color: black;">营销</span>金额区域，</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">公式中IF(MONTH($A$2:$A$13)=D2的<span style="color: black;">暗示</span>假设提取的月份<span style="color: black;">其中</span>等于1月份的，</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> <span style="color: black;">那样</span>将对所在本月的数值进行求和。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> <span style="color: black;">重要提示：当<span style="color: black;">伴侣</span>们输入好公式后，<span style="color: black;">必定</span>要CTRL+SHIFT+ENTER三键<span style="color: black;">同期</span>按钮，函数公式才 能有效。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2279bf0d0971472ca218f472624ce153~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727970223&x-signature=PdHVThxpr7q7A48viKX6o0ImxCU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">回车确认后，单元格右下角十字加号往下拉，<span style="color: black;">就可</span>完成所有求和公式。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">我的分享就到<span style="color: black;">这儿</span>了，<span style="color: black;">倘若</span>对你有<span style="color: black;">帮忙</span>，欢迎<span style="color: black;">大众</span>关注、评论、转发！</p>
页:
[1]