弱者为何要战斗
Have you ever had trouble trying to count items based on two criteria? Don't worry – it's Underdog to the rescue!
您是否曾经尝试过根据两个条件对项目进行计数? 别担心-这是救援的失败者!
Note: There's a short sound clip in the video, so turn down your speakers if your co-workers are napping.
注意:视频中有一个简短的声音片段,因此,如果您的同事正在小睡,请调低扬声器。
VIDEO IS NO LONGER AVAILABLE
视频不再可用
使用SUMPRODUCT进行计数 (Use SUMPRODUCT to Count)
As Underdog mentioned, you can use the SUMPRODUCT function to count items using multiple criteria. In the video, the formula was:
如Underdog所述,您可以使用SUMPRODUCT函数使用多个条件对项目进行计数。 在视频中,公式为:
=SUMPRODUCT(–(B2:B8="Sun"),–(C2:C8="Yes"))
= SUMPRODUCT(–(B2:B8 =“ Sun”),–(C2:C8 =“ Yes”))
There are other tips for counting in Excel on my Contextures website.
在我的Contextures网站上还有其他关于在Excel中进行计数的提示。
翻译自: https://contexturesblog.com/archives/2009/06/17/excel-for-underdogs/
弱者为何要战斗