Count Instances of value in two columns
On Oct 23, 9:42 am, KN wrote:
Hi,
I am trying to count the occurrences of a word in two columns. For
example if column A has the value "YES" and column B also has the
value "YES" then I want to count that as one instance of meeting the
condition that both columns must be YES in order to count the instance
in a third column. So the value of column C would be "1".
I can easily do this for one column using the COUNTIF function as
follows:
=COUNTIF(App_Inventory!A1:A10, "YES")
Thanks
KN
TRY THIS IN COLUMN C
=IF(A4="yes",IF(B4="yes",1,0),0)
|