所以我的问题是如下:我有一张表,用于记录我的项目中出现的风险。他们从关键到低,分别是开放或关闭。我想要一个只计算开放行动至关重要的公式。到目前为止,我已经得到了= 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
发布评论