I have been looking at different forums and I hope someone could help me here. I want to conditionally format a cell based on certain criteria The below would be a master table from which I will need to select data
我一直在寻找不同的论坛，我希望有人可以帮助我。我想根据某些条件有条件地格式化单元格下面是一个主表格，我需要从中选择数据
and compute the values in this table
并计算此表中的值
So, in the formula, I want to see how Phil's time is allocated across three Sprints. So, I will need to look at Sprint column in table 1 and search for Sprint 1, find Phil assigned to Sprint 1 and add the "estimate" total in table 2.
因此，在公式中，我想看看Phil的时间是如何分配三个Sprint的。因此，我需要查看表1中的Sprint列并搜索Sprint 1，找到Phil分配给Sprint 1并在表2中添加“估计”总计。
I saw something like this on the forum, but, no luck. I also tried using lookups and index and all I see are errors. If you have an easy way of solving for this, I would really appreciate.
我在论坛上看到了类似的东西，但没有运气。我也尝试使用查找和索引，我看到的都是错误。如果你有一个简单的方法来解决这个问题，我真的很感激。
2 个解决方案
#1
1
You can use SUMIFS
您可以使用SUMIFS
The formula in B2 is:
B2中的公式是：
=SUMIFS($I:$I,$J:$J,$A2,$G:$G,B$1)
#2
0
This looks like a pretty basic sumifs.
这看起来像一个非常基本的sumifs。
=SUMIFS(Table1[estimate], Table1[sprint], H$2, Table1[assignee], $G3)
Don't drag the formula to fill the other cells. Copy and paste into the larger area. Dragging will shift the column references like relative cell addressing. Copying and pasting will treat the structured table references as absolute.
不要拖动公式来填充其他单元格。复制并粘贴到更大的区域。拖动将移动列引用，如相对单元格寻址。复制和粘贴会将结构化表引用视为绝对引用。
#1
1
You can use SUMIFS
您可以使用SUMIFS
The formula in B2 is:
B2中的公式是：
=SUMIFS($I:$I,$J:$J,$A2,$G:$G,B$1)
#2
0
This looks like a pretty basic sumifs.
这看起来像一个非常基本的sumifs。
=SUMIFS(Table1[estimate], Table1[sprint], H$2, Table1[assignee], $G3)
Don't drag the formula to fill the other cells. Copy and paste into the larger area. Dragging will shift the column references like relative cell addressing. Copying and pasting will treat the structured table references as absolute.
不要拖动公式来填充其他单元格。复制并粘贴到更大的区域。拖动将移动列引用，如相对单元格寻址。复制和粘贴会将结构化表引用视为绝对引用。