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

=SUMPRODUCT(--(A2:A100="Yes"),--(B2:B100="Yes"))


--


Regards,


Peo Sjoblom



"KN" wrote in message
oups.com...
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

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)