Re: Count Instances of value in two columns

Tech-Archive recommends: Fix windows errors by optimizing your registry

Please refrain from multiposting, you have an answer in you other post


--


Regards,


Peo Sjoblom



"KN" <Kamal.Jama@xxxxxxxxx> wrote in message
news:1193150606.378682.94890@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: 0xc0000078 error on W2k3 after dcpromo
    ... Please try and refrain from multiposting. ... Microsoft MVP - Windows Server - Directory Services ... Prev by Date: ...
    (microsoft.public.windows.server.active_directory)
  • Re: How can I do this?
    ... Please refrain from multiposting, ... For everyone's benefit keep the discussion in the newsgroup. ... Peo Sjoblom ...
    (microsoft.public.excel.worksheet.functions)
  • Re: integration between struts and servlet auth
    ... Please refrain from doing so. ... Multiposting is when the number of reposting reaches the number of 3 ... TREMALNAIK ...
    (comp.lang.java.programmer)
  • Re: JButton is split
    ... Sub: JButton is split ... Please refrain from multiposting in future. ... But still I did not get any response in c.l.j.g also. ...
    (comp.lang.java.gui)