Excel：CountIf Quandry [英] Excel: CountIf Quandry

问题描述

感谢您的帮助提前！

所以我的问题是如下：我有一张表，用于记录我的项目中出现的风险。他们从关键到低，分别是开放或关闭。我想要一个只计算开放行动至关重要的公式。到目前为止，我已经得到了= COUNTIF（Risks！E：E，Critical），它正确地计算了关键风险的数量，但显然不考虑它们是开放还是关闭。我尝试在开始时使用änIF语句，但发现= IF（Risks！H：H =Open，COUNTIF（Risks！E：E，Critical））并没有真正返回我需要的。 p>

我绝对记得让这个工作以前工作，但我想我也许使用VBA？过了一段时间，因为我使用excel！

任何帮助非常感谢！

Ed

解决方案

使用COUNTIFS（）：

  = COUNTIFS（Risks！E：E，Critical，Risks！H：H，Open）
  

COUNTIFS（）允许使用多个标准。

Thanks for your help in advance!

So my problem is the following; I have a sheet which I use to log risks that come up in my project. They are graded from Critical to Low, and are either "Open" or "Closed". I want a formula that will count only the open actions which are critical. So far i've got =COUNTIF(Risks!E:E,"Critical"), which correctly counts the number of critical risks, but obviously doesn't take into account if they are open or closed. I tried using än IF statement at the start, but found that =IF(Risks!H:H="Open",COUNTIF(Risks!E:E,"Critical")) wasn't really returning what I needed.

I definitely remember getting this to work before, but I'm thinking perhaps I used VBA? Been a while since I've used excel!

Any help much appreciated!

Ed

解决方案

Use COUNTIFS():

=COUNTIFS(Risks!E:E,"Critical",Risks!H:H,"Open")

COUNTIFS() allows the use of multiple criteria.

这篇关于Excel：CountIf Quandry的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！