英文:
The sum of values whose second column is 1
问题
我想要计算状态为1的价格总和！我该怎么做？
英文:
I have two columns in Excel!
The first column of prices
And the second column of the status, whose values are 1 and 0!
I want to the sum of the prices whose status is 1!
How do I do this?
Columns A1:A5 are for prices |||| Columns B1:B5 are for statuses ||| Section G2 is for the sum total
答案1
得分: 0
SumIf公式是您的最佳选择。它可以比较广泛的数据范围并输出特定的结果。
A1:A5是价格。
1是条件
B1:B5是状态
=SUMIF(A1:A5,">1",B1:B5)
您可以在此处了解更多关于SumIf函数的信息。
英文:
The SumIf formula would be your best fit. It can compare a wide range of data and output specific results.
A1:A5 is the Price.
>1 is the criteria
B1:B5 is the status
=SUMIF(A1:A5,">1",B1:B5)
You can read more about the SumIf function here
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论