IF条件-连接多个列 [英] IF Condition - Join Multiple Columns

问题描述

我需要计算一个术语出现的次数.不幸的是，这些术语组织得不好，因此一个术语可能会出现在多个列中-因此我不能只使用=If(A1="HEALTH",1,0)，因为HEALTH出现在A，B，C等多个列中.

I need to tally the number of times a term appears. Unfortunately, the terms were not well organized so a term may appear in more than one column - so I can't use just =If(A1="HEALTH",1,0) because HEALTH appears in multiple columns A, B, C etc.

我已经尝试过嵌套-=IF(A1="HEALTH",1,IF(B2="HEALTH",1,0))-但是在那儿也没有太大的成功.

I've tried nesting - =IF(A1="HEALTH",1,IF(B2="HEALTH",1,0)) - but haven't had much success there either.

也许我的公式有误?还是我应该在Excel中寻找其他条件?如果是，那是什么?

Maybe my formula's wrong? Or should I look to a different condition in Excel and if so, which?

推荐答案

似乎是

Seems a case for COUNTIF. Say your data is in A1:H1:

=COUNTIF(A1:H1,"HEALTH")

这篇关于IF条件-连接多个列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！