本文介绍了在Excel中计算选择值的总和的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我的工作表中有两列.第一列包含数值(货币)，第二列与其相邻，定义其状态(已付款或到期).我是否可以为一个单元格设置一个公式，以计算第一列中值在下一行中已支付的总和?
I have two columns in my sheet. The first column contains the numeric values (money) and the second column, adjacent to it, defines its status (paid or due).Is there a formula I can set for a cell that calculates the sum of the values in the first column which has the status paid in the next row?
推荐答案
您可以使用以下公式对其求和.假设您的钱"列为B1:B4，而A1:A4是您的已付款或应付款状态
You can use the formula like below to sum it. assuming your money column is B1:B4 and A1:A4 is your paid or due status,
=SUMIFS(B1:B4,A1:A4,"paid")
谢谢.
这篇关于在Excel中计算选择值的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！