组合VLOOKUP，IF OR和STDEV [英] Combining VLOOKUP, IF OR, and STDEV

问题描述

在Excel中，我有两列.一个拥有玩家的名字，另一个拥有得分.像这样:

In Excel I have two columns. One has a player's name and the other has points scored. Like this:

Player  Points
Foo     10
Bar     11
Foo     23
Test    9
Joe     1
Foo     2

我想做的是获取球员综合名单的积分标准差.

What I'm trying to do is get the standard deviation of the points for a combined list of players.

例如，如果我有此列表:

For example, if I had this list:

Foo
Bar

我希望使用10、11、23和2的标准格式，因为这是与这两个玩家匹配的值.

I would want the standard devation of 10, 11, 23, and 2, since those are the values that match those two players.

我尝试过以下公式:

=STDEV(IF(OR(A:A="Foo",A:A="Bar"),B:B,""))

但是我得到的答案与我在应使用的单个数字上使用STDEV公式的答案不同.

but I get a different answer than if I were to use the STDEV formula on the individual numbers that it should be using.

有人知道这是否可能吗?谢谢！

Anyone know if this is possible? Thanks!

推荐答案

您可以使用以下数组公式(Ctrl + Shift + Enter):

You can use following array formula (Ctrl+Shift+Enter):

=STDEV(IF((A:A="Foo")+(A:A="Bar")>0;B:B))

这篇关于组合VLOOKUP，IF OR和STDEV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！