在Excel中计算选择值的总和 [英] Calculating Sum in Excel for select values

问题描述

我的工作表中有两列.第一列包含数值(货币)，第二列与其相邻，定义其状态(已付款或到期). 我是否可以为一个单元格设置一个公式，以计算第一列中值在下一行中已支付的总和?

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中计算选择值的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！